Re: SELECT <all fields except "bad_field"> from mytbl;

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Rodrigo De León <rdeleonp(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SELECT <all fields except "bad_field"> from mytbl;
Date: 2007-05-30 02:04:19
Message-ID: 20070530020419.GA5481@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rodrigo De León escribió:

> Now see:
>
> http://www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html#PLPGSQL-RECORDS-ITERATING

Just a quick reminder that it's usually painful to build "generic"
functions in plpgsql because it's not prepared to deal with column or
table names built at run time. Trying PL/perl or others may prove
simpler.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Naz Gassiep 2007-05-30 02:13:16 Re: TimeZone List
Previous Message Stuart Cooper 2007-05-30 01:24:17 Re: prepare()