On Thu, Sep 25, 2003 at 08:46:39PM -0700, Josh Berkus wrote:
>
> NULLIF is the converse of COALESCE().
Oh, ooops! My apologies.
> Any idea when you're going to overhaul the CookBook?
*sighs*
The software is pretty much ready. I'll have time to install and configure
it next week, after my e
Roberto,
> > Another problem is in creating function...
> > How can i create a function that accept and return any type. the type
> > "any" is not allowing as parameter or return type. Is it possible? i want
> > to create a function similar to NULLIF().
>
> Use the standard coalesce().
NULLIF is
Thanks to all of you for your valuable suggesstions
does postgresql internally uses the = operator(text,text) for any other purposes.
i think that overloading it solves the index problem too...
Tom Lane <[EMAIL PROTECTED]> wrote:
Josh Berkus <[EMAIL PROTECTED]>writes:>> How can i create a f
On Wed, Sep 24, 2003 at 23:30:08 -0600,
Roberto Mello <[EMAIL PROTECTED]> wrote:
> On Wed, Sep 24, 2003 at 08:35:50PM -0700, George A.J wrote:
>
> > Another problem is in creating function...
> > How can i create a function that accept and return any type. the type "any" is not
> > allowing as
Josh Berkus <[EMAIL PROTECTED]> writes:
>> How can i create a function that accept and return any type. the type "any"
>> is not allowing as parameter or return type. Is it possible? i want to
>> create a function similar to NULLIF().
> You can't, nor will you be able to -- in te future, some 7.4
On Wed, Sep 24, 2003 at 08:35:50PM -0700, George A.J wrote:
> hai
>
> i am using postgresql 7.3.x. I am converting a database in MS SQL server to
> PostgreSQL.
>
> The main problems i am facing is that in sql server the text comparisons are case
> insensitive. how can i compare text case ins
On Wed, 24 Sep 2003, George A.J wrote:
> The main problems i am facing is that in sql server the text comparisons
> are case insensitive. how can i compare text case insensitive in
> postgresql without using an upper() or lower() function in both sides
> (=). Is there any option to set in postgre
jinujose,
> i am using postgresql 7.3.x. I am converting a database in MS SQL server to
> PostgreSQL.
Good luck to you!
> The main problems i am facing is that in sql server the text comparisons
> are case insensitive. how can i compare text case insensitive in postgresql
> without using an uppe
hai
i am using postgresql 7.3.x. I am converting a database in MS SQL server to PostgreSQL.
The main problems i am facing is that in sql server the text comparisons are case insensitive. how can i compare text case insensitive in postgresql without using an upper() or lower() function in both
