and update
doesn't like of empty values, so
UPDATE SET (t1,t2,t3,t4,t5,t6,t7,t8) = (t1,t2,t3,,t5,,,)
generates error.
Best regards,
Teemu Juntunen, e-ngine
ing a column
you could have a select result of 5 columns and fields for 6 columns.
Best regards,
Teemu Juntunen
- Original Message -
From: "J Ottery"
To:
Sent: Saturday, December 27, 2008 7:47 AM
Subject: [GENERAL] Bind message has 6 results formats but query has 5
columns
VALUES (1);
INSERT INTO child (foo,hoo) VALUES (1,1);
DELETE FROM master WHERE foo=1;
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Teemu Juntunen" <[EMAIL PROTECTED]>
Cc: "PostgreSQL"
Sent: Saturday, November 08, 2008 7:01 A
chlid FOR EACH ROW EXECUTE
PROCEDURE fn_td_y();
with no help. Any other ideas?
Regards,
Teemu Juntunen
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Teemu Juntunen" <[EMAIL PROTECTED]>
Cc: "PostgreSQL"
Sent: Friday, Novembe
REPLACE FUNCTION fn_td_y() RETURNS trigger AS
$BODY$
DECLARE
fi integer;
BEGIN
SELECT i INTO fi FROM master WHERE x = old.x;
...
It seems that SELECT results to null, so the master has already deleted the
row. Is this intended and how can I solve this?
Regards,
Teemu Juntunen
;;
END IF;
END LOOP;
RETURN 1;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION fn_triggerall(DoEnable boolean) OWNER TO postgres;
COMMENT ON FUNCTION fn_triggerall(DoEnable boolean) IS 'Enable/disable all the
triggers in database';
- Original Message
table names and construct the
needed commands in strings. If so, how to get all the tablenames from database?
Best regards and thanks!
Teemu Juntunen
could put the product manufacturers in one string, but I
would like to have them in columns.
How about arrays. Is there a way to SELECT values in an array to columns?
Best regards and thanks,
Teemu Juntunen
Hi all,
is there some way to disable and enable login in PostgreSQL? I would like to
have only local login enabled when the server starts and make some checks
before allowing general login.
Best regards and thanks,
Teemu Juntunen
ify database with
SELECT query?
I'm developing an ERP where I would like to implement a statistical program
where you can write your own SELECT queries.
Best Regards,
Teemu Juntunen
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscripti
nswer with many solutions!
Best regards,
Teemu Juntunen
-Alkuperäinen viesti-
Lähettäjä: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Puolesta Tomasz Ostrowski
Lähetetty: 28. maaliskuuta 2008 18:20
Vastaanottaja: Teemu Juntunen
Kopio: pgsql-general@postgresql.org
Aihe: Re: [GENERAL] De
Shop code
2. Order number
3. Row number
Receipt row:
1. Shop code
2. Date
3. Cash desktop code
4. Receipt number
5. Row number
I am using PostgreSQL 8.2.5 at the moment.
Best regards,
Teemu Juntunen
Shop code
2. Order number
3. Row number
Receipt row:
1. Shop code
2. Date
3. Cash desktop code
4. Receipt number
5. Row number
I am using PostgreSQL 8.2.5 at the moment.
Best regards,
Teemu Juntunen
13 matches
Mail list logo
