Re: [SQL] Calling void functions
I'm informed that the last statement of a function that returns void cannot be a SELECT. How else is one supposed to call another function which also returns void? PERFORM ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [SQL] Calling void functions
am Mon, dem 02.04.2007, um 8:52:09 -0400 mailte Daniel Caune folgendes: I'm informed that the last statement of a function that returns void cannot be a SELECT. How else is one supposed to call another function which also returns void? PERFORM PERFORM works only in plpgsql, Peter wrote a pl/sql-function... Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: - Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [SQL] Calling void functions
Peter Eisentraut [EMAIL PROTECTED] writes: I'm informed that the last statement of a function that returns void cannot be a SELECT. How else is one supposed to call another function which also returns void? Hmm, seems like the best answer is to rejigger the order of the tests in check_sql_fn_retval. I think that logic was designed before we had an idea of VOID-returning functions. regards, tom lane ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [SQL] Calling void functions
PERFORM works only in plpgsql, Peter wrote a pl/sql-function... Oups, sorry! I missed the point. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org