On Sun, Aug 20, 2006 at 10:56:12PM -0700, Neil Conway wrote:
On Mon, 2006-08-21 at 07:31 +0200, Hans-Juergen Schoenig wrote:
CREATE OR REPLACE FUNCTION xy() RETURNS SETOF record AS $$
SELECT relname::text, relpages::int4
FROM pg_class;
$$ LANGUAGE SQL IMMUTABLE;
Jim C. Nasby wrote:
On Sun, Aug 20, 2006 at 10:56:12PM -0700, Neil Conway wrote:
On Mon, 2006-08-21 at 07:31 +0200, Hans-Juergen Schoenig wrote:
CREATE OR REPLACE FUNCTION xy() RETURNS SETOF record AS $$
SELECT relname::text, relpages::int4
FROM pg_class;
$$
As my last mail did not seem to go through here one more try ...
When looking at some fairly complex SQL stuff I came across some
interesting issue which is a bit surprising to me:
CREATE OR REPLACE FUNCTION xy() RETURNS SETOF record AS $$
SELECT relname::text, relpages::int4
On Mon, 2006-08-21 at 07:31 +0200, Hans-Juergen Schoenig wrote:
CREATE OR REPLACE FUNCTION xy() RETURNS SETOF record AS $$
SELECT relname::text, relpages::int4
FROM pg_class;
$$ LANGUAGE SQL IMMUTABLE;
As far as i remember inlined SQL code has been implemented into the