' ;
select * from test where col2 like E'N';
select * from test where col2 =E'\\N';
Why use `like' here at all?
Bertram
--
Bertram Scharpf
Stuttgart, Deutschland/Germany
http://www.bertram-scharpf.de
---(end of broadcast)---
TIP 4: Have you
as administrator
Sorry. I am bored to write this and you are bored to read
this: starting with or turning to Postgres is a good
opportunity to convince your customer to use an OS rather
than a relegating makeshift.
Bertram
--
Bertram Scharpf
Stuttgart, Deutschland/Germany
http://www.bertram-scharpf.de
Hi,
Am Freitag, 23. Feb 2007, 07:10:06 + schrieb Richard Huxton:
Bertram Scharpf wrote:
it is very inconvenient for me that triggers aren't inherited:
Foreign keys too (which are a special type of trigger of course).
Is this behaviour to be implemented at any point of time
a trigger for each descending table definitely
dosn't satisfy me.
Thanks in advance,
Bertram
--
Bertram Scharpf
Stuttgart, Deutschland/Germany
http://www.bertram-scharpf.de
---(end of broadcast)---
TIP 5: don't forget to increase your free space
://developer.postgresql.org/pgdocs/postgres/auth-methods.html.
(This is available under Windows.)
What is Windows?
Bertram
--
Bertram Scharpf
Stuttgart, Deutschland/Germany
http://www.bertram-scharpf.de
---(end of broadcast)---
TIP 3: Have you
it: thanks a lot for your
answers and for the discussion.
Bertram
--
Bertram Scharpf
Stuttgart, Deutschland/Germany
http://www.bertram-scharpf.de
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
rolname=$1; $$;
CREATE FUNCTION
sandbox=# select validate_user_8_1('joe','verysecret');
validate_user_8_1
---
t
(1 Zeile)
May I rely on this in future versions or are there more
sophisticated ways to do it?
Thanks in advance,
Bertram
--
Bertram Scharpf
Stuttgart
Hi,
Am Dienstag, 16. Jan 2007, 15:51:58 -0500 schrieb Tom Lane:
Bertram Scharpf [EMAIL PROTECTED] writes:
Is there a deeper reason why the foreign key allows not
referenced non-null values
The SQL spec says so. Use MATCH FULL to get the behavior you want.
Ah, I should have seen
for
every occurrence of the columns pair.
Is there a deeper reason why the foreign key allows not
referenced non-null values or is there an easy way to fix
the whole behaviour?
Thanks in advance,
Bertram
--
Bertram Scharpf
Stuttgart, Deutschland/Germany
http://www.bertram-scharpf.de
