Re: [SQL] pl/pgsql Limits

Najm Hashmi wrote: Hi All, As it is known that any funtion, written in pl/pgsql, can only retrun one tuple. I am just wondering it were true as well for function written in C language. I need to write few function that will retrun mulitiple rows satsifying a certain set of conditions.

Re: [SQL] pl/pgsql Limits

Jan Wieck [EMAIL PROTECTED] writes: As it is known that any funtion, written in pl/pgsql, can only retrun one tuple. I am just wondering it were true as well for function written in C language. I need to write few function that will retrun mulitiple rows satsifying a certain set of

[SQL] how to select a time frame on timestamp rows.

Hello, today i was trying to perform a query on a database using a time stamp field, i need to get all records which belong to year 2000, month 11, is there any other way to doit, or is this the pgsql way? , actually i'm using a query like this: select User_Name from tbacct where

Re: [SQL] how to select a time frame on timestamp rows.

[EMAIL PROTECTED] writes: today i was trying to perform a query on a database using a time stamp field, i need to get all records which belong to year 2000, month 11, is there any other way to doit, or is this the pgsql way? , actually i'm using a query like this: select User_Name

[SQL] Using INDEX on date/time values // Re: how to select a time frame on timestamp rows.

Hi, Peter Eisentraut schrieb: today i was trying to perform a query on a database using a time stamp field, i need to get all records which belong to year 2000, month 11, [...] select user_name from tbacct where extract(month from acct_timestamp) = 11 ... is there any way of using