Re: [SQL] How to convert 3 colums to timestamp with timezone

On Sun, Oct 03, 2004 at 22:50:13 +0200, Jens Arnfelt <[EMAIL PROTECTED]> wrote: > Hi There! > > Hope this is an easy one :-D > > How do I convert 3 individuel colums with type "date", "time" and > "integer" to at timestamp with timexone? > > eg. tabel > cStartUnixtimecStartTimecStart

[SQL] How to convert 3 colums to timestamp with timezone

Hi There! Hope this is an easy one :-D How do I convert 3 individuel colums with type "date", "time" and "integer" to at timestamp with timexone? eg. tabel cStartUnixtimecStartTimecStartZone 09-24-200410:27:12-2 This I have to present as an timestamp with timezone. Thanks in advan

Re: [SQL] Concurrency problem

Dag Gullberg <[EMAIL PROTECTED]> writes: > Warning: pg_query(): Query failed: ERROR: tuple concurrently updated > CONTEXT: PL/pgSQL function "get_rights" line 5 at SQL statement in > /home/site/PHP/db_func.php on line 301 > Code of get_rights: > GRANT SELECT ON c.users TO > adm,w3;

Re: [SQL] Postgres Doubt

On Sep 27, 2004, at 11:27 PM, sreejith s wrote: Hello, I am new to PostgreSQL. I have a doubt. Now i am doing one project in .NET technology with postgres(linux) as database. I am using pgADMIN and pgManager as tools for database releted activities. Now i am able to create functions with 'sql

Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?

> The reason this doesn't work is that the timestamp to date conversion > depends on the time zone setting. In theory you should be able to avoid > this by specifying the time zone to check the date in. I tried something > like the following which I think should work, but doesn't: > create idxfoo

[SQL]

Hi all! If I made a C function, let's say "ext_data", with an int input parameter and RECORD or user defined type (but always only one row) as a output, would I be able to write a SQL query like: SELECT st.*, ext.* FROM SomeTable st, ext_data(st.ID) ext WHEREcondition only on Som

Re: [SQL] SELECT with Function

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Paulo Nievierowski wrote: | PS: Excuses my poor english. Your english is excellent. MY is poor!! | I create plpgsql function "myfunc(integer)" thats returns of type | record with values from table X (the function decides what record must | be select). T

[SQL] Postgres Doubt

Hello, I am new to PostgreSQL. I have a doubt. Now i am doing one project in .NET technology with postgres(linux) as database. I am using pgADMIN and pgManager as tools for database releted activities. Now i am able to create functions with 'sql' language. When i select 'pgsql' as language fo

[SQL] Error : could not send data to client

Hello, Perhaps could you help me... We work under Windows. Postgres is installed and functions in the form of service NT (postmaster). We also use a service "cron" which carries out regular tasks (same than the crontab under Linux). We added an order (carried out every hour) in the "crontab" who

[SQL] date_trunc'd timestamp index possible?

I'm trying to create a index from a timestamp+tz field and want the index to be date_trunc'd down to just the date when i try to do a create idxfoo on foo (date(footime)); i get a ERROR: DefineIndex: index function must be marked IMMUTABLE and it chokes on when i try to use the date_trunc()

[SQL] Concurrency problem

Hi, I have a problem with concurrency, where ordinary selects render me Warning: pg_query(): Query failed: ERROR: tuple concurrently updated CONTEXT: PL/pgSQL function "get_rights" line 5 at SQL statement in /home/site/PHP/db_func.php on line 301 Code of get_rights: GRANT SELECT