I've got three tables, I'll shorten the columns down just so you get the
idea:
lists
---
id|order_id
list_results
id|lid|total
orders
id|max
All of the columns are int's. What I'm trying to do is something like:
select (o.max-coalesce(sum(lr.total),0)) from o
I'm migrating an Oracle 9 database over to Postgres 7.3.4, and just ran
into something I've never seen before (honestly, due to my lack of
experience in Oracle) and was curious if
Postgres supported anything similar. The DBA that set up Oracle
appears to have enabled Oracle Label Security, whi
then go into the console themselves and create a view
giving them full access to the table?
Or, maybe I'm way off on this whole thing
On Jan 26, 2004, at 1:06 PM, Bruno Wolff III wrote:
On Mon, Jan 26, 2004 at 12:45:40 -0800,
James Taylor <[EMAIL PROTECTED]> wrote:
I'm migrating an
