> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Marco Lazzeri
> Sent: Saturday, January 24, 2004 7:19 AM
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] If table A value IS NULL then table B
>
> > I think this post belongs on the SQL list, not the gener
""Bob Powell"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> To whom it may concern:
>
> I find the recent articles in various trade publications a little
> disturbing due to the lack of PostgrSQL mention. I continue to see
> articles about how IBM may be considering MYSQL for dev
r that you need to be sure
the sequence isn't being invoked somewhere else? E.g., a trigger or a
default value or ??? (Or, of course, another session...)
== Ezra Epstein
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
l.org
Searched pages from postgresql.org for SECURITY INVOKER. Results 1 -
10 of about 141. Search took 0.23 seconds.
Ahhh, that's better.
Or use site:www.postgresql.org to avoid the archive listings, etc.
== Ezra Epstein
""D. Dante Lorenso"" <[EMAIL PROTECT
Ahhh. Yes. A nasty typo. I did a global search for %1, %2, %3, etc. and
turned up several elsewhere. Ouch. Thank you for your close reading.
== Ezra Epstein
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "ezra epstein" <[EMAIL PR
Up too late. This works fine. At least it works for some simpler test
functions under the just-downloaded 7.4.1 release.
-- Ezra Epstein
"ezra epstein" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I'm been banging my head over this for a little while
Aother head banger for me.
Below is a complete example of the code
Using Postgres 7.4,
the function "test" gets this: psql:temp3.sql:10: ERROR: syntax error
at or near "%" at character 135
the function "test2" gets this: psql:temp3.sql:10: ERROR: syntax error
at or near "ROWTYPE" at char
y detected...'';
END IF;
There's also a short-cut way to do this since you use Serial for the CatIDs.
Just do a CHECK (CatParent < CatID) -- of course it makes an assumption
about the CatIDs really come in serially...
== Ezra Epstein
""Tony (Unihost)"&
I'm been banging my head over this for a little while now.
Here's a simple function to return a record:
CREATE OR REPLACE FUNCTION create_item_record_for_override(INTEGER,
VARCHAR )
RETURNS RECORD AS '
DECLARE
recRECORD;
BEGIN
/* Normally we would not have a separ
f
everything.)
EE
"Jan Wieck" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> There is a way to create them as CONSTRAINT triggers. It's totally
> non-standard, not guaranteed to exist in future releases, yadda, yadda.
> But it get's you where you want
10 matches
Mail list logo
