Fernando --
I have forwarded your message to the postgres SQL list where it started -- it
is good practice to "cc" the list in general so that others can contribute /
learn.
If you could provide the version of postgres you are using that might help, as
there differences between 7.x and 8.x tha
Hello everybody!!!, I'd like to know if there another way to get the time from a timestamp type, because in earliest versions I just get the time like time(fecha) and now
this returns an error, thanks in advanced!!!
[PostgreSQL 7.4RC2 on i686-pc-linux-gnu](I know, I know... must upgrade soon)
I have a table mytable like:
i | txt
---+---
1 | the
2 | the
3 | rain
4 | in
5 | mainly
6 | spain
7 | stays
8 | mainly
9 | in
I want to update it, adding a ':' to txt so that each txt value is unique.
I
I think its cause you changed your procedure from being written in SQL to
being writtern in PLPGSQL in your second implementation
Sets of records are returned from a PLPGSQL function with a RETURN statement
... not a SELECT...
Check out the sections of the manual that talk about PLPGSQL...
There are some tools.. search about Ora2PG or so
One other way to go is to have the Oracle DB dumped out as text and
change/review the statements to suit your new structure and PG
differences
You definitely need mass changing tools with regular expressions.
On 11/9/05, zenith Das <[EMAIL PROTECT
Hello everybody!!!, I'd like to know if there another way to get the time from a timestamp type, because in earliest versions I just get the time like time(fecha) and now this returns an error, thanks in advanced!!!
On Thu, 2005-11-10 at 09:03 -0600, Judith Altamirano Figueroa wrote:
> Hello everybody!!!, I'd like to know if there another way to get the
> time from a timestamp type, because in earliest versions I just get
> the time like time(fecha) and now this returns an error, thanks in
> advanced!!!
r
On Thu, Nov 10, 2005 at 01:11:27PM -0500, Rod Taylor wrote:
> rbt=# select cast(now() - date_trunc('day', now()) as time);
> time
> -
> 13:10:42.495579
> (1 row)
Am I missing something? Is there a reason not to simply cast the
timestamp value to time?
test=> select cast(no
On Thu, 2005-11-10 at 11:21 -0700, Michael Fuhr wrote:
> On Thu, Nov 10, 2005 at 01:11:27PM -0500, Rod Taylor wrote:
> > rbt=# select cast(now() - date_trunc('day', now()) as time);
> > time
> > -
> > 13:10:42.495579
> > (1 row)
>
> Am I missing something? Is there a reason
[Please copy the mailing list on replies.]
On Thu, Nov 10, 2005 at 12:24:17PM -0600, Judith Altamirano Figueroa wrote:
> excuse me and how can I just get the hour, minute and second
The time type takes an optional precision:
test=> select now()::time;
now
-
11:36:3
Michael Fuhr <[EMAIL PROTECTED]> writes:
> Am I missing something? Is there a reason not to simply cast the
> timestamp value to time?
> test=> select now()::time;
>now
> -
> 11:19:19.892125
> (1 row)
> test=> select cast(now() as time);
>now
>
On Thu, Nov 10, 2005 at 02:13:43PM -0500, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > Am I missing something? Is there a reason not to simply cast the
> > timestamp value to time?
>
> I think the OP was trying to use the functional cast syntax
> time(now())
> which worked
So I don't open a new thread..
I have a table with a column of type TIMESTAMP.
In output, I need to format it.. what's the best way to do it?
So, for instance, how could I format it so that it would output as YY-MM-DD
HH:MM?
Regards,
Tadej
-Original Message-
From: [EMAIL PROTECTED] [mail
On Thu, Nov 10, 2005 at 08:29:07PM +0100, Tadej Kanizar wrote:
> I have a table with a column of type TIMESTAMP.
> In output, I need to format it.. what's the best way to do it?
> So, for instance, how could I format it so that it would output as YY-MM-DD
> HH:MM?
See to_char() in the "Data Type F
We currently use a system with 4 tables (division, region,
district, location).
The data for the most part has a field named location id.
The users get a level and location id (if they are district
it would represent a district id etc).
I have been asked to make this more flexible, fo
On Thu, Nov 10, 2005 at 10:58:18 -0500,
george young wrote:
> [PostgreSQL 7.4RC2 on i686-pc-linux-gnu](I know, I know... must upgrade soon)
>
> I have a table mytable like:
> i | txt
> ---+---
> 1 | the
> 2 | the
> 3 | rain
> 4 | in
> 5 | mainly
> 6 | spain
> 7 | stays
> 8 | mai
16 matches
Mail list logo
