[SQL] PostgreSQL downloads

2001-10-01 Thread Miguel González
Does anyone where there is a web site or ftp site where i can download the latest release of PostgreSQL? I have been trying to use the ftp://ftp.postgresql.org but it doesnt work properly. Many thanks in advance Miguel ---(end of broadcast)--- TI

Re: [SQL] PostgreSQL downloads

2001-10-01 Thread Philip Hallstrom
Hi - http://www.us.postgresql.org/sites.html has a whole list of them... On Mon, 1 Oct 2001, [iso-8859-1] Miguel González wrote: > Does anyone where there is a web site or ftp site where i can download the > latest release of PostgreSQL? I have been trying to use the > ftp://ftp.postgresql.org

Re: [SQL] On Differing Optimizer Choices ( Again)

2001-10-01 Thread Oleg Lebedev
Hi, this is a very silly question, but how do I run PL/pgSQL function from SQL? I created a function test(varchar, varchar) and I am trying to invoke it with parameters 'hello', 'world' using an SQL statement. I tried selects and executes - nothing works. Please help, Oleg Mark kirkwood wrote:

Re: [SQL] Calling Functions

2001-10-01 Thread Josh Berkus
Oleg, > Hi, > this is a very silly question, but how do I run PL/pgSQL function > from SQL? > I created a function test(varchar, varchar) and I am trying to invoke > it with > parameters 'hello', 'world' using an SQL statement. I tried selects > and executes > - nothing works. > Please help, SEL

[SQL] using SQL to evaluate arbitrary expressions?

2001-10-01 Thread Markus Wagner
Hi, we need to process user-defined integrity conditions, which are stored as strings at application level, e. g. "person.age - 2 > 18". We would like to substitute the variable names within these expressions by their values at trigger time. So we have expressions containing constants only, e.

Re: [SQL] using SQL to evaluate arbitrary expressions?

2001-10-01 Thread Tom Lane
Markus Wagner <[EMAIL PROTECTED]> writes: > We are glad to have found out that we can evaluate such expressions > simply by calling them with SELECT, e. g. "SELECT 29 - 2 > 18" returns true. > We think that it would be very nice to benefit from the pg database system > parser. But can we rely o