Re: [SQL] Re: [HACKERS] Counting bool flags in a complex query

2000-10-06 Thread Tom Lane
"Josh Berkus" <[EMAIL PROTECTED]> writes: >> Just FYI, I have committed code for 7.1 that allows ORDER BY to work >> correctly for a UNION'd query. A limitation is that you can only do >> ordering on columns that are outputs of the UNION: > As far as I know, that limitation is standard to all SQ

[SQL] Windows 9X

2000-10-06 Thread Craig May
Hi, Has anyone installed postgresql on a box running Win9X, if so, could you provide some pointers on getting started. Regards, Craig May Enth Dimension http://www.enthdimension.com.au

Re: [SQL] Re: [HACKERS] Counting bool flags in a complex query

2000-10-06 Thread Josh Berkus
Tom, > Just FYI, I have committed code for 7.1 that allows ORDER > BY to work > correctly for a UNION'd query. A limitation is that you > can only do > ordering on columns that are outputs of the UNION: As far as I know, that limitation is standard to all SQL that supports UNION; the relational

Re: [SQL] Granting of permissions on tables

2000-10-06 Thread Tom Lane
"Saltsgaver, Scott" <[EMAIL PROTECTED]> writes: > After I ran into this condition, the first thing I tried was to grant > permissions back to myself. PostgreSQL shot me down with a permission > denied error. So I had to log is as the superuser and then grant > permissions to myself. Are you sur

RE: [SQL] Granting of permissions on tables

2000-10-06 Thread Saltsgaver, Scott
After I ran into this condition, the first thing I tried was to grant permissions back to myself. PostgreSQL shot me down with a permission denied error. So I had to log is as the superuser and then grant permissions to myself. Thanks for everyone's help. So would an exceptable workaround be t