pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alexander Kunz <alexander.kunz@nextra.de>
To: pgsql-sql@postgresql.org
Subject: Re: trouble using FOR ... IN EXECUTE query LOOPs in PL/pgSQL
Date: Tue, 6 Nov 2001 20:29:46 +0100
Message-ID: <9s9dki$g01$1@news.tht.net> (raw)
References: <85256AFC.0060FA3E.00@procyon.terc.edu>

Hi Jon,

the field for a loop must be from type record. I have insert some line, but
not testet. ( No time to do this )

> CREATE FUNCTION check_foreign_key ( varchar(32), varchar(32), integer )
> RETURNS text AS '
>      DECLARE
>           table_name ALIAS FOR $1;
>           field_name ALIAS FOR $2;
>           field_value ALIAS FOR $3;
>           key_check_query TEXT;
>           check_count INTEGER;
>           field_value_exists BOOLEAN := ''f'';
------->    rec RECORD;
>
>      BEGIN
>           key_check_query :=
>           (
>           ''SELECT COUNT(*) AS check_count FROM ''
>                || quote_ident(table_name)
>                || '' WHERE ''
>                || quote_ident(field_name)
>                || '' = ''
>                || quote_literal(field_value)
>                || '';''
>           );
>
>           FOR rec IN EXECUTE key_check_query LOOP
-------->       ^^^
>                IF rec.check_count > 0 THEN
-------->           ^^^
>                     field_value_exists := ''t'';
>                END IF;
>                EXIT;
>           END LOOP;
>
>           RETURN field_value_exists;
>      END;
> ' LANGUAGE 'plpgsql';

Regards,
alexander
--
-------------------------------------------------------------------------
Nextra Deutschland       | Alexander Kunz
GmbH & Co. KG            | Capacity Planning & Optimization
Region Mitte             | Tel.:  +49 (0)6151 88008-897
Birkenweg 14a            | Fax:   +49 (0)6151 88008-500
64295 Darmstadt          | Mobil: +49 (0)175 9309601
http://www.nextra.de     | E-Mail: alexander.kunz@nextra.de
-------------------------------------------------------------------------





view thread (4+ messages)  latest in thread

Message-ID: <9s9dki$g01$1@news.tht.net>
Permalink:  ../9s9dki$g01$1@news.tht.net/
Also on:    postgresql.org/message-id/9s9dki$g01$1@news.tht.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: alexander.kunz@nextra.de
  Subject: Re: trouble using FOR ... IN EXECUTE query LOOPs in PL/pgSQL
  In-Reply-To: <9s9dki$g01$1@news.tht.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox