Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> I'm fairly sure this query is illegal per spec. There are ancient > >> discussions in the archives about whether aggregates in an UPDATE target > >> list can have a consistent interpretation or not. We never found one, > >> but never got around to disallowing it either. Maybe it's time. If you > >> try it with something like sum() you don't get a crash, but you do get > >> rather bizarre behavior. > > > Yeah, I agree we should disallow it. For the curious, the bizarre behavior > > is > > > alvherre=# update pk set id = count(id) ; > > ERROR: ctid is NULL > > Hmm, what version are you testing? What I see is that it updates a > single one of the table rows :-(
The trick seems to be that the table must be empty. I'm doing this in 8.1.3. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
