Re: [SQL] A SQL Question About distinct, limit, group by, having,

On Thu, 2005-03-31 at 13:14 +0800, Lin Kun Hsin wrote: > below is the sql schema. i hope it will help. > > i want the top 3 score students in every class this has been discussed before. a quick google gives me: http://archives.postgresql.org/pgsql-sql/2004-04/msg00067.php gnari

[SQL] Help - Oracle 9i to PostgreSQL SQL conversion

Hi,   I have installed PostgreSQL 8.0.1 on Solaris 9.   I am porting my database from Oracle 9i to PostgreSQL. I am using PL/pgSQL language.   In Oracle we can get error message from "SQLERRM" keyword and inserting it into table.   How can I get error message/code in PostgreSQL after an E

Re: [SQL] A SQL Question About distinct, limit, group by, having, aggregate

Actually, i have a method to solve this problem. But i really want to know, we have to write more statement to do one thing? First step, we have to create 2 sequence. Let call them "foo" and "foo1". create sequence foo; create sequence foo1; then, you can run below statement, and you will see t

Re: [SQL] New record position

There's a difference between "natural" order (the location in the database or on disk) and "record" order (the order specified by the primary key)... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Browne Sent: Wednesday, March 30, 2005 3:04 PM To

Re: [SQL] New record position

[EMAIL PROTECTED] ("Greg Patnude") writes: > There's a difference between "natural" order (the location in the > database or on disk) and "record" order (the order specified by the > primary key)... That's well and fine; I could see the "natural order" in which data is returned varying over time i

[SQL] unsubscribe pgsql-sql

unsubscribe pgsql-sql ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [SQL] unsubscribe pgsql-sql

Robin M. wrote: unsubscribe pgsql-sql ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org roger doger, copy that tower 2, bravo delta. -- No virus found in this outgoing message. Checked b

[SQL] asynchrous triggers

hi folks, is it possible somehow to make (AFTER) triggers run in their own process/thread, so the calling session can return immediately and the trigger runs in background ? thx -- - Enrico Weigelt== metux IT service

Re: [SQL] asynchrous triggers

On Fri, Apr 01, 2005 at 05:52:49AM +0200, Enrico Weigelt wrote: > is it possible somehow to make (AFTER) triggers run in their > own process/thread, so the calling session can return immediately > and the trigger runs in background ? Not really, though you could signal an external process to do s