"James M Doherty" <[EMAIL PROTECTED]> writes:
> declare
> SQL text;
> NSQLtext;
> SQL := ''10/3/2009'';
> NSQL := quote_literal(SQL);
> The result is '10/3/2009 with no closing quote.
Works for me:
regression=# create function foo() returns text as '
regression'# declar
On Wed, 2005-11-30 at 12:42, Luis Silva wrote:
> I there, I'm trying to work with postgre, but i'm having a problem
> with inherits. I have a table (parent) that as an fk to another table.
> When i create a child, i loose the connection to the other table. i
> dont need to insert values in the par
Nmostlikemat := ''10/3/2009'';
What happens is that quote_literal works for everyone in the example but
this one.
Jim
James M Doherty
Principal
JMD CONSULTING
411 Thunderbay Dr
Georgetown, TX 78626
A reputation is something others give you HONOR is something you give
yourself!
-Original
declare
SQL text;
NSQLtext;
SQL := ''10/3/2009'';
NSQL := quote_literal(SQL);
The result is '10/3/2009 with no closing quote.
Jim
James M Doherty
Principal
JMD CONSULTING
411 Thunderbay Dr
Georgetown, TX 78626
A reputation is something others give you HONOR is som
"James M Doherty" <[EMAIL PROTECTED]> writes:
> I have had the following problem and been unable to determine the cause !
Can you show us a complete example? I can't see what's going on from
the info you've provided ...
regards, tom lane
---(end o
I have had the following problem and been unable to determine the cause !
nmostlikemat := iso_date(nmostlikemat);
EXECUTE ''insert into scenario_inv (''
|| ''inv_id,''
|| ''record_date,''
|| ''scenario_type,''
|| ''mostlikemat,''
|| ''mktpr,''
|| ''mktyld )''
I there, I'm trying to work with postgre, but i'm
having a problem with inherits. I have a table (parent) that as an fk to another
table. When i create a child, i loose the connection to the other
table. i dont need to insert values in the parent table. what do i need to
do?? tks in advanc
On Sat, 15 Oct 2005 08:49:15 +
"paperinik 100" <[EMAIL PROTECTED]> threw this fish to the penguins:
> PostgreSQL is 7.4.7.
>
> My first table
> CREATE TABLE tb_cat (
> id INTEGER,
> desc text
> );
> INSERT INTO tb_cat VALUES (10, 'cat10');
> INSERT INTO tb_cat VALUES (20, 'cat20');
> INSERT I
El Mié 30 Nov 2005 09:57, Neil Saunders escribió:
> Apologies if this has been mentioned on announce (I'm not subscribed),
> but the mailing list archive site appears to have a problem (403
> Forbidden):
>
> http://archives.postgresql.org/
I'm checking the archives right now, without a problem.
Apologies if this has been mentioned on announce (I'm not subscribed),
but the mailing list archive site appears to have a problem (403
Forbidden):
http://archives.postgresql.org/
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner wi
NosyMan wrote:
Hi everyone,
I have some kind of strange problem. I want to build general parametrized
trigger for my database. The parameter sent to the trigger contains a column
name that trigger should be check.
The 'vt' variable contains the column name. In the above statement I want th
Hi everyone,
I have some kind of strange problem. I want to build general parametrized
trigger for my database. The parameter sent to the trigger contains a column
name that trigger should be check.
CREATE OR REPLACE FUNCTION F_T_IU__check() RETURNS trigger AS $$
DECLARE
12 matches
Mail list logo
