Re: function and passing the table name to be used with SQL stmnt

From: kamiseq <kamiseq(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: function and passing the table name to be used with SQL stmnt
Date: 2007-10-29 19:37:32
Message-ID: 1193686652.895955.39770@v3g2000hsg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> SELECT INTO _id id FROM _tabela order by id desc limit 1;

ok I ve found that

EXECUTE 'SELECT id FROM ' || quote_ident(_tabela) ||' order by id desc
limit 1' INTO _id;

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-10-29 19:46:27 Re: Inheritance problem when restoring db
Previous Message bharat u 2007-10-29 19:28:22 reg. rewrite rules