Re: [GENERAL] Pl/PgSQL String formatting like raise?

Pavel, thank you very much for your answer. -- Best Regards, Csaba Együd there is nothing similar. You should to use module plvsubst from Orafce http://www.postgres.cz/index.php/Oracle_functionality_(en)#PLVsubst regards Pavel Stehule 2009/2/11 Csaba Együd : Hi, is there a way in a Pl/PgSQL

[GENERAL] Pl/PgSQL String formatting like raise?

Hi, is there a way in a Pl/PgSQL function (PG 8.1.* / 8.3.*) to cut together a string value like it is done for RAISE Note/Exception? I'd like to use s.g. like this : StrVar := 'select * from t1 where f1=% and f2=%', quote_literal(Param1),quote_literal(Param2); Many Thanks! csaba --

[GENERAL] Database schema & data synchronizer software for PostgreSQL?

gards, Csaba Együd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Updatable Views - DEFAULT doesn't inherit from table???

"Richard Huxton" <[EMAIL PROTECTED]> a következőket írta üzenetében news:[EMAIL PROTECTED] Csaba Együd wrote: Thx for your reply. Is there any possible way to generate an sql to "copy" these defaults to the view. Nothing pre-packaged that I know of. You could pro

Re: [GENERAL] Updatable Views - DEFAULT doesn't inherit from table???

table seem to be far away from perfect, too many fields, you should chop it into few smaller tables. 2008/12/5 Csaba Együd <[EMAIL PROTECTED]>: Hi, thx for your reply too. Not that I guess because there is a default row in qtyunits with id=-1. Too many fields: How would you chop this

Re: [GENERAL] Updatable Views - DEFAULT doesn't inherit from table???

"Richard Huxton" <[EMAIL PROTECTED]> a következőket írta üzenetében news:[EMAIL PROTECTED] Csaba Együd wrote: Hi, I have problems with inserting rows into an updatable view through it's insert rule. [snip] But in the table definition I defined DEFULT=(-1) for this fiel

[GENERAL] Updatable Views - DEFAULT doesn't inherit from table???

nt ** Error ** ERROR: null value in column "qtyunitid" violates not-null constraint SQL state: 23502 But in the table definition I defined DEFULT=(-1) for this field. What's going wrong? Shouldn't it inherit these settings from the table? Many thanks, -- Bes

Re: [GENERAL] How to define automatic filter condition?

Sure, no problem. Please avoid top-posting. Regards, Andreas -- Great, thanks. -- Csaba -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to define automatic filter condition?

"" <[EMAIL PROTECTED]> a következoket írta üzenetében news:[EMAIL PROTECTED] am Wed, dem 12.11.2008, um 8:08:08 +0100 mailte Csaba Együd folgendes: Hi All, --PG8.3 --Windows 2k3 SBS I would like to apply an automatic filter condition to a table. I create a TEMP table at the beginning

[GENERAL] How to define automatic filter condition?

Hi All, --PG8.3 --Windows 2k3 SBS I would like to apply an automatic filter condition to a table. I create a TEMP table at the beginning of the session to store a value to build up a filter condition and I would like to apply this condition to every select statement to a table during the current