[GENERAL] ORDER BY a string

2007-11-06 Thread phazon
"**" are ignored in the order by. Can anyone explain me why ? PS: Sorry for my bad english, i'm french. -- phazon ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

[GENERAL] prepare, execute & oids

2006-08-01 Thread phazon
Hello, i've this kind of query:PREPARE preparedInsert (varchar) AS  INSERT INTO my_table (my_field)  VALUES ($1);  ');and i use it with: EXECUTE preparedInsert ('test'); I juste want to get the OID of the line inserted. Does anyone know how to do it ?Thanks,Phazon

Re: [GENERAL] prepare, execute & oids

2006-08-02 Thread phazon
imary key of all the line inserted. 2006/8/1, Michael Fuhr <[EMAIL PROTECTED]>: On Tue, Aug 01, 2006 at 06:19:29PM +0200, phazon wrote:> I juste want to get the OID of the line inserted. Does anyone know how to do> it ?It depends on the client interface.  What interface are you using? OIDs a