Re: [BUGS] BUG #7831: user defined-aggregated don't set initcond to null when unspecified, instead uses its first argument

2013-01-27 Thread Abel Abraham Camarillo Ojeda
On Sun, Jan 27, 2013 at 10:53 PM, Tom Lane wrote: > acam...@verlet.org writes: >> user defined-aggregated don't set initcond to null when unspecified, instead >> uses its first argument. > > And your point is? > > AFAICS this is the documented behavior when the transition function > is strict. Se

Re: [BUGS] BUG #6205: ERROR: temporary tables cannot specify a schema name

2011-09-14 Thread Abel Abraham Camarillo Ojeda
On Wed, Sep 14, 2011 at 4:49 PM, Alvaro Herrera wrote: > > Excerpts from Abel Abraham Camarillo Ojeda's message of miƩ sep 14 18:33:33 > -0300 2011: > >> Cannot create temporary tables without using CREATE TEMP, >> if I hardcode 'pg_temp' as a schema _and_ the table uses >> a unique constraint on

[BUGS] BUG #6205: ERROR: temporary tables cannot specify a schema name

2011-09-14 Thread Abel Abraham Camarillo Ojeda
The following bug has been logged online: Bug reference: 6205 Logged by: Abel Abraham Camarillo Ojeda Email address: acam...@verlet.org PostgreSQL version: 9.1.0 Operating system: OpenBSD-current/amd64 Description:ERROR: temporary tables cannot specify a schema name

Re: [BUGS] BUG #6064: != NULL, <> NULL do not work

2011-06-17 Thread Abel Abraham Camarillo Ojeda
Do not write expression = NULL because NULL is not "equal to" NULL. (The null value represents an unknown value, and it is not known whether two unknown values are equal.) This behavior conforms to the SQL standard. http://www.postgresql.org/docs/9.1/static/functions-comparison.html On Fri, Jun

[BUGS] Fwd: Difference in postgres9.0.4 and postgres9.1beta1 when displaying error lines in functions with comments

2011-06-09 Thread Abel Abraham Camarillo Ojeda
I should have posted this here before sending it to pgsql-hackers... ups. -- Forwarded message -- From: Abel Abraham Camarillo Ojeda Date: Thu, Jun 9, 2011 at 8:58 PM Subject: Difference in postgres9.0.4 and postgres9.1beta1 when displaying error lines in functions with comments