; ;
> select * from test where col2 like '\\N' ;
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
dministrator account
> 3. Login 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
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 implem
Reimplemeting 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
<http://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)--
he function I proposed.
Before I decide how I will solve 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
password from
pg_authid where 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
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 wa
ced value pair. I were bored
if I had to fix this behaviour with check constraints 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
--
Bertra
