On Tue, Jan 22, 2013 at 2:31 PM, wrote:
> The statement:
> 'CREATE EXTENSION uuid-ossp'
>
> just gives me a syntax error:
>
> ERROR: syntax error at or near "-"
> LINE 1: CREATE EXTENSION uuid-ossp
> ^
> ** Fehler **
>
> ERROR: syntax error at or near
On Thu, Oct 18, 2012 at 5:40 PM, wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7612
> Logged by: Maxim Boguk
> Email address: maxim.bo...@gmail.com
> PostgreSQL version: 9.2.1
> Operating system: Linux
> Description:
>
> Join between two values
On Fri, Apr 27, 2012 at 03:12, Tom Lane wrote:
> Does anybody else have an opinion as to which of these solutions is
> more preferable?
>
I think all unquoted whitespace should be ignored, so I prefer your
solution. (note: I haven't actually tested it, I'm going off these emails)
> And should
On Wed, Jan 25, 2012 at 22:19, Giuseppe Sucameli wrote:
> thinking you have no skills, I wrote a patch too and posted it to
> hackers ML about 2 days ago, but I didn't subscribe that list so
> it is stalled, waiting for someone's approval.
>
> For this reason my email is not displayed in the archi
On Tue, Jan 24, 2012 at 14:41, Giuseppe Sucameli wrote:
> > I would try to cook up a patch but I have no skills :-(
>
> I'm going to write a patch to fix this problem.
I managed to put something together and have posted it on hackers.
On Mon, Jan 23, 2012 at 11:25, Marc Balmer wrote:
> Am 22.01.12 14:22, schrieb Giuseppe Sucameli:
> > test=> create table lx (xmin int);
> > ERROR: column name "xmin" conflicts with a system
> > column name
> >
> > test=> create table lx (i int);
> > CREATE TABLE
> > test=> alter table lx add xm
On Thu, Sep 1, 2011 at 10:27, Incorrect result from operator wrote:
>
> SELECT ('2011-08-31'::date,'2011-08-31'::date) overlaps
> ('2011-08-1'::date,'2011-08-31'::date);
> Returns false, should return true.
>
According to the documentation, it should return false.
"Each time period is considere
On Sun, Mar 6, 2011 at 14:29, wrote:
> The only workaround that I can think of is to use a dummy variable to
> capture the query result. This has to be done even when the query doesn’t
> have a result (as when calling a function returning void).
>
>
>
> do
>
> $$declare
>
> dummy record;
>
> begi
