Re: [SQL] Week of the Year?

John, Would you have any clue how to figure out the first saturday of any month - 6 days and the last saturday of that month? I know that this seems odd but i have to run reports for "Non Standard Months" and well I am clueless. At 09:55 PM 8/11/00 -0500, you wrote: >Try using the function d

Re: [SQL] Week of the Year?

On Sun, 3 Sep 2000, Brian C. Doyle wrote: > John, > > Would you have any clue how to figure out the first saturday of any month - > 6 days and the last saturday of that month? > > I know that this seems odd but i have to run reports for "Non Standard > Months" and well I am clueless. > > At

[SQL] Re: Auto increment

In article , "Mads Jensen" <[EMAIL PROTECTED]> wrote: > Hi > > I'm a newbiw with pgsql: > > 1: Haven't been able to find the officiel manual to pgsql. What's the > complete URL? Hmm, I don't know, I use the book which you can find with all the rest of the docs at:

[SQL] Order by in stored functions

Hello I tried to create the following function CREATE Function pGetMenu ( int ) returns setof varchar As ' SELECT IdMenuShow || IdWebPage FROM Menu WHERE IdMenu = $1 ORDER BY IdSort ; ' language 'SQL' ; I've got the following error message: ERROR: function declared t

[SQL] pg_hba.conf

Hi, I'm recieving an error "No pg_hba.conf entry for host XXX, usr XXX, database XXX." I've modified the pg_hba.conf.sample file to allow all access, however still getting the same message. Any suggestions? Regards, Craig May