Jesper Krogh wrote:
Tom Lane wrote:
Jesper Krogh writes:
Shouldnt the like operator do the same as the = if there occours no
wildcards and stuff in the string?
If there are also no escape characters, then yeah.
FWIW, 8.4 will complain about this case:
regression=# select E'\\&#x
Tom Lane wrote:
Jesper Krogh writes:
Shouldnt the like operator do the same as the = if there occours no
wildcards and stuff in the string?
If there are also no escape characters, then yeah.
FWIW, 8.4 will complain about this case:
regression=# select E'\\' like E'\\';
Hi.
Can anyone explain me this behavior?
testdb=# select E'\\' = E'\\';
?column?
--
t
(1 row)
testdb=# select E'\\' like E'\\';
?column?
--
f
(1 row)
Shouldnt the like operator do the same as the = if there occours no
wildcards and stuff in the string?
--
Jesper
--
Sen
Tom Lane wrote:
> Jesper Krogh <[EMAIL PROTECTED]> writes:
>> ... the right-hand-side of on
>> in operation will allways be a list (if I havent forgotten something).
>
> IN (SELECT ...) for one thing.
Isn't that "just" a list of rows(complex value)
Aaron Bono wrote:
> On 11/2/06, Tom Lane <[EMAIL PROTECTED]> wrote:
>>
>> Jesper Krogh <[EMAIL PROTECTED]> writes:
>> > Whereas this gives a syntax error:
>>
>> > # select 1 in ();
>> > ERROR: syntax e
e use ORM's for accessing the
database.. thus it would be nice if the SQL implementation was a bit
more generic like a "language".
Jesper
--
Jesper Krogh, [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
