in the select result?
Sam
--
Samuel Tardieu -- [EMAIL PROTECTED] -- http://www.rfc1149.net/sam
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Chester == Chester Kustarz [EMAIL PROTECTED] writes:
On Wed, 28 Jan 2004, Chester Kustarz wrote:
On Wed, 28 Jan 2004, Samuel Tardieu wrote: If in a transaction I
call an embedded function in Pl/PgSQL, in which I have:
delete from t where condition; for e in select distinct on (f
HINT: For example, FROM (SELECT ...) [AS] foo.
Why isn't the as c considered as an alias?
Sam
--
Samuel Tardieu -- [EMAIL PROTECTED] -- http://www.rfc1149.net/sam
---(end of broadcast)---
TIP 2: you can get off all lists at once
On 2/01, Michael Glaesemann wrote:
| I'm not quite sure what you want the query to return, but you've got a
| problem with your parentheses.
I can't believe this :) I got hit by the inner query needs to be aliased
message and added it to the wrong place and them munged the query a lot.
The
On 3/01, Samuel Tardieu wrote:
| On 2/01, Michael Glaesemann wrote:
|
| | I'm not quite sure what you want the query to return, but you've got a
| | problem with your parentheses.
|
| I can't believe this :) I got hit by the inner query needs to be aliased
| message and added it to the wrong
is quite a pretty usual operation.
Thanks in advance.
Sam
PS/ the real problem is more complex, as we need to do those
statistics on several fields, not only catid
--
Samuel Tardieu -- [EMAIL PROTECTED] -- http://www.rfc1149.net/sam
---(end of broadcast
On 2/06, Richard Huxton wrote:
| You want to use triggers not rules here (see the server programming and
| procedural language manual sections). A trigger will be fired for each row
| inserted/deleted/updated. Of course this means it will be fired 5000 times
| for 5000 updated rows.
Ouch. At