[SQL] Getting the row_count value outside of a function

2003-11-09 Thread enio
I can get the row_count value inside of a function, 
but I can“t get it outside of a function. 

How can I do this?

Regards,
Enio

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[SQL] Sometimes referential integrity seems not to work

2004-01-31 Thread Enio Schutt Junior
In a database I am working, I sometimes have to delete all the records in
some tables. According to the referential integrity defined in the creation
of the tables, postmaster should not delete the records, but it does. I have 
used the following commands: "delete from table_1" and "truncate table_1".
When deleting records individually, referential integrity works (postmaster 
does not allows deletion of records which are referred by another table).
Is there some difference between deleting records individually or at once?
Is there any possibility of the user who does this deletion (postgres, normal 
users) affects the behaviour of referential integrity in the tables? That is, 
can the postgres user delete records despite referential integrity?

Thanks. 


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])