>directory, such as /usr/lib/postgresql/site-stuff (cf. perl), but this
>sort of a arrangement is a major pain. For instance, it won't allow
>non-root installs.
>
--
Timothy H. Keitt
Department of Ecology and Evolution
State University of New York at Stony Bro
[EMAIL PROTECTED]:
450 4.7.1 ... Can not check MX records for recipient host techjockey.net
-- Original message omitted --
--
Timothy H. Keitt
Department of Ecology and Evolution
State University of New York at Stony Brook
Stony Brook, New York 11794 USA
Phone: 631-632-1101, FAX: 631-632-7626
Anyone maintaining generic autoconf scripts for linking against libpq,
i.e., returns path to libpq-fe.h and proper link options?
Tim
--
Timothy H. Keitt
Department of Ecology and Evolution
State University of New York at Stony Brook
Stony Brook, New York 11794 USA
Phone: 631-632-1101, FAX
Hmmm... that's good to know. Basically, I'm trying to model fixed order
tables in another application through a proxy mechanism (see
http://rpgsql.sourceforge.net/). I guess I will have to force row
ordering on all proxied tables.
Tim
Tom Lane wrote:
> "Timothy H. Keitt&
I see this (subselect) is available in >=7.1.
Tim
Timothy H. Keitt wrote:
> Hi,
>
> It appears that limit and offset do not work in a subselect such as:
>
> update my_table set my_col = new_val where oid = (select oid from
> my_table offset row_number limit 1);
>
update my_table set my_col = new_val offset row_number limit 1;
But this is not supported either.
Tim
--
Timothy H. Keitt
Department of Ecology and Evolution
State University of New York at Stony Brook
Phone: 631-632-1101, FAX: 631-632-7626
http://life.bio.sunysb.edu/ee/keitt/
compile a list and post it back to pgsql-hackers.
Thanks.
Tim
--
Timothy H. Keitt
Department of Ecology and Evolution
State University of New York at Stony Brook
Phone: 631-632-1101, FAX: 631-632-7626
http://life.bio.sunysb.edu/ee/keitt/