Re: MySQL search query is not executing in Postgres DB - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: MySQL search query is not executing in Postgres DB
Date
Msg-id CAHyXU0w1d-3Mbu2sU6v4neywJ5ntW3ATV6r6-4N4vLgMBNRYEQ@mail.gmail.com
Whole thread Raw
In response to Re: MySQL search query is not executing in Postgres DB  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: MySQL search query is not executing in Postgres DB  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Tue, Nov 27, 2012 at 10:52 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> it is a basic problem - PostgreSQL has unique possibilities -
> polymorphic parameters and almost all databases doesn't support
> overloading

Speaking of polymorphism, why not just implement lpad()'s first
argument as 'anyelement'?  ISTM this comes up in mostly in porting
code from other database that is utilizing standard sql functions.
This should be appropriate when the function's basic functionality and
argument signature is not dependent on input type (constrast:
to_timestamp) and there is a good portability case to be made.
Essentially, this applies to a handful of string processing routines
AFAICT.

merlin



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Problem Observed in behavior of Create Index Concurrently and Hot Update
Next
From: Robert Haas
Date:
Subject: Re: Re: Problem Observed in behavior of Create Index Concurrently and Hot Update