Re: functions with plpgsql

From: "Bernd Hoffmann" <info(at)unixserver(dot)info>
To: <pgsql-php(at)postgresql(dot)org>
Subject: Re: functions with plpgsql
Date: 2003-08-10 00:33:36
Message-ID: 025d01c35ed7$0ad4e590$3214a8c0@server
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

Hallo Andy,

> I do not think you can evaluate a declared vairable as a table name in the
> SELECT statement.

where can I find some docu about declare a table by variable.

> I don't think you really need to do this though. If you have the table
name
> already.
> why go:
> SELECT next_id(logs);
> SELECT MAX(id) + 1 FROM logs;

it's only a example, I got everytime the error:

PostgreSQL meldet: ERROR: parser: parse error at or near "$1"

PS.: Excuse me, for my bad english :)

MfG

Bernd

In response to

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Brad Bulger 2003-08-10 04:53:17 Re: functions with plpgsql
Previous Message Andrew J. Kopciuch 2003-08-10 00:04:10 Re: functions with plpgsql