Re: Why overlaps is not working

From: Jorge Godoy <jgodoy(at)gmail(dot)com>
To: "Andrus" <eetasoft(at)online(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why overlaps is not working
Date: 2006-11-11 12:26:35
Message-ID: 87odregoec.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Andrus" <eetasoft(at)online(dot)ee> writes:

> This causes error
>
> ERROR: syntax error at or near "IF"
> SQL state: 42601
> Character: 109

SQL has no "IF". Use plpgsql instead.

> How many times this is slower than expression in where clause?

You can time it. :-) But I don't believe it will be too slow since it is a
simple operation...

--
Jorge Godoy <jgodoy(at)gmail(dot)com>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-11-11 15:46:41 Re: Why overlaps is not working
Previous Message Andrus 2006-11-11 11:58:56 Re: Why overlaps is not working