[SQL] INSERT DELETE RETURNING

Hi All, As per Daniel Caune's posting (with no replies) on October 22nd, (http://archives.postgresql.org/pgsql-sql/2006-10/msg00195.php), Can I do this.? INSERT INTO stock_deleted_tmp ( code, description, date_deleted ) DELETE FROM ONLY stock_tmp WH

Re: [SQL] Proper way of iterating over the column names in a trigger function. [ SOLVED]

On 12/6/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes: > what is the proper way for iterating over column names of a table using > SPI_* functions. You need to pay attention to the attisdropped field of the TupleDesc entries. thanks. did the below (h

[SQL] Query is fast and function is slow

The query select count(*) from documents where doc_num = '106973821' and (select bit_or(group_access) from mda_groups where group_name in (select groname from pg_user,pg_group where usename = 'bbob' and usesysid = any(grolist) and (groname ~ '.*owner$' or groname = 'admin'))) & access > '0

Re: [SQL] Proper way of iterating over the column names in a trigger function.

"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes: > what is the proper way for iterating over column names of a table using > SPI_* functions. You need to pay attention to the attisdropped field of the TupleDesc entries. regards, tom lane ---(end o

[SQL] Count field in query

Hi all. Is there any way to build a query with a field that has the IndexCount of the query. It's something like the number of the row returned (starting with 1). Something like: select * from mytable order by name; id | name | CountField 7 | KK | 1 98 | LL | 2 5 | ZZ

[SQL] Proper way of iterating over the column names in a trigger function.

Hi, I am trying to interate over column names of a table on which a C trigger function is called on UPDATE/DELETE and INSERT. SPI function char * SPI_fname(TupleDesc rowdesc, int colnumber) is being used. looks like the function is returning column names like "pg.dropped.2" for d