How compare current_setting(..) ?

From: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-sql(at)postgresql(dot)org
Subject: How compare current_setting(..) ?
Date: 2007-02-22 10:25:42
Message-ID: erjr2t$sdn$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi there,

I'd like to check that my log_line_prefix is set to '%t'.
I suppose I can check it with the following statement:
SELECT current_setting( 'log_line_prefix' )
WHERE current_setting( 'log_line_prefix' ) != '%t'

But it returns every time a row, with '%t', even when log_line_prefix is set
to '%t'.
What's wrong ?

TIA,
Sabin

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2007-02-22 11:03:54 Re: How compare current_setting(..) ?
Previous Message A. Kretschmer 2007-02-21 21:37:06 Re: Problems with temp table and PL