Re: [SQL] Tracking depth question

From: Zalman Stern <zalman(at)netcom(dot)com>
To: zot(at)zotconsulting(dot)com (Zot O'Connor)
Cc: pgsql-sql(at)hub(dot)org
Subject: Re: [SQL] Tracking depth question
Date: 1999-11-05 06:48:05
Message-ID: 199911050648.WAA06502@netcom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> scatdepth integer DEFAULT (SELECT scatval from scattab where scatval =
> scatscat) + 1,

I think you mean "(SELECT scatdepth from scattab where scatval = scatscat)
+ 1" . (Perhaps you might consider calling scatscat "scatparent" instead.)

How about defining a function and setting the default to its return value?

-Z-

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Frederic boucher 1999-11-05 07:09:37 Re: [SQL] Accessing other database...
Previous Message Frederic boucher 1999-11-05 05:16:32 Re: [SQL] Accessing other database...