Thank you for reply.
>concat() invokes datatype output functions, which are not necessarily
>immutable. An easy example is that timestamptz_out's results depend
>on the TimeZone setting.
I understood.
-
Regards,
Vinayak,
--
View this message in context:
http://postgresql.1045698.n5.na
Vinayak writes:
> The pg_catalog.concat() is defined as STABLE function.
> why was STABLE preferred for concat() over IMMUTABLE?
concat() invokes datatype output functions, which are not necessarily
immutable. An easy example is that timestamptz_out's results depend
on the TimeZone setting.
Hello,
The pg_catalog.concat() is defined as STABLE function.
As per my understanding a STABLE function cannot modify the database and is
guaranteed to return the same results given the same arguments for all rows
within a single statement.
Example:
current_timestamp family of functions qualify a
You're not from Texas, are you? :-)
Christopher Browne wrote:
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] ("scott.marlowe") transmitted:
Given the third choice, I'd throw the switch.
Why is it that I think of something _completely_ different when you
use the ph
On 16 Sep 2003 at 14:36, Marek Lewczuk wrote:
> >
> > You want to use the || operator, e.g. 'hello' || ' ' || 'world'
>
> I know that, but in my application (which is working on MySQL now) I
> have many querys which use CONCAT function, so I need to implement this
> function is PG - there is no
>
> You want to use the || operator, e.g. 'hello' || ' ' || 'world'
I know that, but in my application (which is working on MySQL now) I
have many querys which use CONCAT function, so I need to implement this
function is PG - there is no possibility to replace (in short time) all
of my querys.
On Tuesday 16 September 2003 13:45, Marek Lewczuk wrote:
> Hello,
> As I'm in the middle of the migration process form mysql to pg I found
> that there is no CONCAT function which is available in mysql. Can
> anybody tell me how to implement this function using plPERL or plPGSQL
> language ?
You w
Hello,
As I'm in the middle of the migration process form mysql to pg I found
that there is no CONCAT function which is available in mysql. Can
anybody tell me how to implement this function using plPERL or plPGSQL
language ?
Best wishes,
ML
---(end of broadcast)-
