[SQL] unsubscribe

2007-02-08 Thread David Klugmann
unsubscribe ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[SQL] Unsubscribe

2006-09-20 Thread David Klugmann
---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [SQL] View unique rowid

2005-06-01 Thread David Klugmann
From: Rafa Couto <[EMAIL PROTECTED]> Reply-To: Rafa Couto <[EMAIL PROTECTED]> To: David Klugmann <[EMAIL PROTECTED]> CC: pgsql-sql@postgresql.org Subject: Re: [SQL] View unique rowid Date: Wed, 1 Jun 2005 16:53:19 +0200 > Is it possible to refer to a unique row identifier o

[SQL] View unique rowid

2005-06-01 Thread David Klugmann
Hi Is it possible to refer to a unique row identifier on a view ? I have the following view but in a subsequent select I need to refer to each row's unique identifier and I know oid's are not valid for a view. create view persontransit as select personid, planet, name as aspectname, position as

[SQL] SELECT statement within libpq

2003-05-31 Thread David Klugmann
Hi I'm knew to postgres and I got my first C postgres connection working from the examples in the documentation. In that it does a BEGIN and a DECLARE CURSOR FOR SELECT et.c. This seems a long way to go about getting back data each time. Is it not possible to just do a straight select and not