Hail PG Gurus,
Can somebody please tell us about concurrency in PG functions?
I am porting some VERY big functions to PG for a data warehousing system
(that is GPL'd BTW) and it seems that the results of one portion of the
function (e.g. a create table or a series of inserts) are invisible to
t
i thick it's epoch() in PostgreSQLcheck your documentation.
Zlatko Calusic wrote:
> Hi!
>
> As subject says, we are currently porting all of our data, programs
> and logic from mysql to postgresql. One of the things we have yet to
> resolve is how to replace mysql's UNIX_TIMESTAMP() functi
There is a sample in postgres documentation. (See below).
the only problem is for using langage plpgsql.
If it is not understand by your database, you must use command
createlang plpgsql dbname
as the owner of the database.
CREATE TABLE emp (
empname text,
salary int4,
Tom Lane wrote:
>
> Max Pyziur <[EMAIL PROTECTED]> writes:
> >> That's pretty bizarre (not to say difficult to believe). What LOCALE
> >> setting are you running the postmaster in?
>
> > On none of the installations - the two 6.5.x and the 7.0.2-2 one - I
> > don't have any locale set. I get (
Max Pyziur <[EMAIL PROTECTED]> writes:
>> That's pretty bizarre (not to say difficult to believe). What LOCALE
>> setting are you running the postmaster in?
> On none of the installations - the two 6.5.x and the 7.0.2-2 one - I
> don't have any locale set. I get (what I think are) correct resul
Tom Lane wrote:
>
> Max Pyziur <[EMAIL PROTECTED]> writes:
> > I've come across what I consider an odd sorting anomaly in 7.0.2-2 where running
> > the following query:
> > select headline from headlines where headline like 'Alb%' order by 1 ;
>
> > The results in the 7.0.2-2 install come back c
Max Pyziur <[EMAIL PROTECTED]> writes:
> I've come across what I consider an odd sorting anomaly in 7.0.2-2 where running
> the following query:
> select headline from headlines where headline like 'Alb%' order by 1 ;
> The results in the 7.0.2-2 install come back case-insensitive and
> oblivious
Greetings,
I've been using postgresql for some time and currently am using it in three
different environments (specific details below) w/ the first two being 6.5.x
releases and the third 7.0.2-2:
I've come across what I consider an odd sorting anomaly in 7.0.2-2 where running
the following que
