Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group