Re: [SQL] Number of rows in a cursor ?

2005-08-24 Thread Thomas Borg Salling
Bo Lorentsen wrote: Is it possible to get the total number of rows found in a cursor, or must I make a count(*) and then a select ? Perhaps: GET DIAGNOSTICS rc = ROW_COUNT; (see http://archives.postgresql.org/pgsql-novice/2003-06/msg00143.php and http://www.postgresql.org/docs/8.0/interacti

Re: [SQL] "Flattening" query result into columns

2005-03-27 Thread Thomas Borg Salling
Scott Marlowe Sendt: 22. marts 2005 01:46 Til: Thomas Borg Salling Cc: pgsql-sql@postgresql.org Emne: Re: [SQL] "Flattening" query result into columns On Mon, 2005-03-21 at 15:57, Thomas Borg Salling wrote: > I am looking for a way to ”flatten” a query result, so that rows are > ”

[SQL] "Flattening" query result into columns

2005-03-21 Thread Thomas Borg Salling
I am looking for a way to ”flatten” a query result, so that rows are ”transposed” into columns, just as asked here for oracle: http://groups.google.dk/groups?hl=da&lr=&client=firefox-a&rls=org.mozilla:en-US:official&selm=aad10be0.0401292322.7b6c320b%40posting.google.com   Is there any wa