Re: [SQL] Using a variable as a view name in a select

ne July  Aug  …. === Falls 1  0  1  0  0 . . . .   Can you think of another way to do this ?     From: Hilary Forbes [ mailto:[EMAIL PROTECTED]] Sent: April 3, 2007 10:14 AM To: Wilkinson, Jim; pg

Re: [SQL] Using a variable as a view name in a select

…   Select * from (select table.start_month||_||table.end_month); == Start_month  = april End_month = May   What I what to pass to the select is the combination of the 2 fields as the view name.   Any ideas ? Hilary Forbes DMR Limited (UK registration 01134804) A DMR Information an

Re: [SQL] System catalog table privileges

is license free.  There's fame for someone there  Hilary At 10:07 21/07/2006 -0500, Aaron Bono wrote: On 7/21/06, Hilary Forbes <[EMAIL PROTECTED]> wrote: Dear All Next question on privileges!  Can I safely remove all privileges from the system catalog tables for a user and still

[SQL] System catalog table privileges

ay of preventing them seeing that tables exist but I don't want them trying to manually update any tables of mine or postgres's thank you very much!  (Don't shoot the messenger - there's no accounting for user's tastes!) TAI Hilary Hilary Forbes DMR Limited (UK registration 01

Re: [SQL] Help with privilages please

. Is this a known bug in this version (7.4.1)? Thanks Hilary At 18:08 20/07/2006 -0400, Tom Lane wrote: Hilary Forbes <[EMAIL PROTECTED]> writes: > I have an existing table suppliers and I have created a new user > 'hilary' > REVOKE ALL on TABLE suppliers FROM hilary; >

[SQL] Help with privilages please

ot solve the problem. Many thanks Hilary Hilary Forbes DMR Limited (UK registration 01134804) A DMR Information and Technology Group company (www.dmr.co.uk) Direct tel 01689 889950 Fax 01689 860330 DMR is a UK registered trade mark of DMR Limited **

Re: [SQL] Where are user defined functions stored?

system tables as well. Is there a way of achieving this? Hilary At 10:40 23/09/2005 -0400, you wrote: >Hilary Forbes <[EMAIL PROTECTED]> writes: >> How can I easily get to see the definition of a user defined function >> please? > >Look in pg_proc. > >

[SQL] Where are user defined functions stored?

nswer. TAI Hilary Hilary Forbes The DMR Information and Technology Group (www.dmr.co.uk) Direct tel 01689 889950 Fax 01689 860330 DMR is a UK registered trade mark of DMR Limited ** ---(end of broa

[SQL] Order of execution of rules

Can I guarantee that if I have more than one Rule on a table they will be executed in a given order? I know triggers are done alphabetically but is the same true of rules? Many thanks Hilary Hilary Forbes The DMR Information and Technology Group (www.dmr.co.uk) Direct tel 01689 889950 Fax

[SQL] Record size

0 but will be upgrading. :-) Hilary Hilary Forbes - DMR Computer Limited: http://www.dmr.co.uk/ Direct line: 01689 889950 Switchboard: (44) 1689 86 Fax: (44) 1689 860330 E-mail: [EMAIL PROT