No idea on the function, but why not have a 'master' ticket table and
have the ones in each schema inherit from it? Then you could query
all tables by just querying the master table.
On Jun 20, 2007, at 5:55 AM, David Abrahams wrote:
Background: I have a number of schemas all of which conta
Background: I have a number of schemas all of which contain a "ticket"
table having the same columns. The goal of the function xticket1
below is to collect all ticket rows satisfying some condition from all
those schemas, and additionally label each one by adding a new column
containing the name o
On Jun 20, 5:55 am, David Abrahams <[EMAIL PROTECTED]> wrote:
> The problem is, psql is complaining:
>
> ERROR: wrong record type supplied in RETURN NEXT
Try:
... RETURNS SETOF RECORD ...
---(end of broadcast)---
TIP 1: if posting/reading throu
