Fwd: [SQL] Inserts with incomplete rows... NOT NULL constraints

2004-08-11 Thread Lars Erik Thorsplass
Sorry about that, forgot to send to the list. -- Forwarded message -- From: Lars Erik Thorsplass <[EMAIL PROTECTED]> Date: Wed, 11 Aug 2004 22:18:24 +0200 Subject: Re: [SQL] Inserts with incomplete rows... NOT NULL constraints To: Peter Eisentraut <[EMAIL PROTECTE

[SQL] Inserts with incomplete rows... NOT NULL constraints

2004-08-11 Thread Lars Erik Thorsplass
Am trying to migrate some old data to a new database schema. I have dumped the old data as SQL statements. The new datastructure just contains some added fields to a few tables. My plan was to just create a new database with the new structure, dump the content only as SQL insert statements. And ju

Re: [SQL] [GENERAL] Stored procedures and "pseudo" fields..

2004-07-20 Thread Lars Erik Thorsplass
On Tue, 20 Jul 2004 09:45:06 -0600, Scott Marlowe <[EMAIL PROTECTED]> wrote: > > Kinda like this: > > > > SELECT *, acl_check( objects.obid, ) AS mode FROM objects > > WHERE mode > 0; > > Here's the problem. In order to do the select, the query first needs to > run the where clause. I.e.: > > s

[SQL] Stored procedures and "pseudo" fields..

2004-07-20 Thread Lars Erik Thorsplass
I also posted this to the general list, which might not have been a suitable forum. -- I have recently ventured into the exciting world of stored procedures, but I have now become lost. Background: Am currently working on access control in a web application. My goal is to process access control