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 u
Peter Eisentraut wrote:
Thanks Peter for the answer, so i assume i can also do
select user_name from tbacct where extract(month from acct_timestamp) =
11 and extract(year from acct_timestamp) = 2000 ...
>
> [EMAIL PROTECTED] writes:
>
> > today i was trying to perform a query on a databa
[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_Nam
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 acct_tim
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
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 conditi
Den lørdag 13. januar 2001 11:42 skrev Rolf Johansson:
> Is there some function to change the serial type to, instead of reading
> a next-value, read the maxium value in a column and then add x? If, for
You can use setval(sequence, number) and MAX(number) in combination.
--
Kaare Rasmussen
