http://www.postgresql.org/download/ http://www.postgresql.org/download/
lists the db drivers for a variety of languages.
_
From: smithveg [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 29, 2007 10:50 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] postgresql connection
Is there a setting to limit the number of database
connections per IP address or client?
Thanks,
Curtis
Im trying to prevent any further input of a
particular field value via an insert rule with the following rule.
CREATE OR REPLACE RULE rule_foovalue AS
ON INSERT TO foo
WHERE new.foovalue = 1 DO SELECT
fooexception.fooexception
FROM fooexception() fooexception(fooexception);
Allan,
Thanks for the reply I guess what I am actually looking for is an example of
a dynamic SQL select statement similar to how a static sql select can select
into a variable.
Thanks,
Curtis
Curtis,
Here is an example function that uses dynamic sql.
I use it under 7.4.5
Hope this helps.
I have a table that I would like to be
able to retrieve information out of based on a combination of multiple columns
and I would like to be able to do this through a plpgsql stored procedure.
Right now I have multiple stored procedures that I am calling based on the
values parameter
I believe you would want to cast the field
to a date like so select datefield::datefrom table1 or select datefield::time from
table1.
From: Chris Hoover
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 25, 2006 11:55
AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Splitting
Does anyone have any examples of how I would make a stored procedure in
plpgsql that would allow for passing a list or arrays of values to be used
in an sql IN clause? Like so: select * from table where field1 in (values).
Is this possible?
Thanks,
Curtis
---(end of
Thanks, Erik another possible solution would also be this.
Here it is in case you are interested.
On 7/18/06, Tony Wasson [EMAIL PROTECTED] wrote:
On 7/18/06, Curtis Scheer [EMAIL PROTECTED] wrote:
Does anyone have any examples of how I would make a stored procedure
in plpgsql that would
