On Thursday 27 March 2008 00:13:26 Adrian Klaver wrote:
> On Wednesday 26 March 2008 5:05 pm, Shawn wrote:
> > Hi Guys,
> >
> > Just a quick question. Is there a known problem with dropping function
> > in 8.2.6? I can make them but they can't be deleted.
> >
> > Shawn
>
> They will not deleted i
On Wednesday 26 March 2008 5:05 pm, Shawn wrote:
> Hi Guys,
>
> Just a quick question. Is there a known problem with dropping function in
> 8.2.6? I can make them but they can't be deleted.
>
> Shawn
They will not deleted if something else depends on them i.e. a trigger.
Can you show the error m
Hi Guys,
Just a quick question. Is there a known problem with dropping function in
8.2.6? I can make them but they can't be deleted.
Shawn
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
On Wednesday 26 March 2008 23:12:07 Rodrigo E. De León Plicet wrote:
> Use dollar quoting, e.g.:
>
> create or replace function dur_interval_msec(int) returns interval
> as
> $$
> select ($1 * interval '1 msec');
> $$
> language sql
> immutable
> returns null on null input;
Perfect! Great! Thank
On Wed, Mar 26, 2008 at 5:45 PM, Shawn <[EMAIL PROTECTED]> wrote:
> obviously it doesn't like the extra single quotes around the 1 msec. Any
> suggestions for a work around?
Use dollar quoting, e.g.:
create or replace function dur_interval_msec(int) returns interval
as
$$
select ($1 * interval
On Wednesday 26 March 2008 17:14:28 Tom Lane wrote:
> Or even easier:
>
> regression=# select 134987 * interval '1 msec';
> ?column?
> --
> 00:02:14.987
> (1 row)
>
>
> regards, tom lane
Tom and Adrian,
i am trying to incorporate the solution you gave int
-- Original message --
From: Tom Lane <[EMAIL PROTECTED]>
> [EMAIL PROTECTED] (Adrian Klaver) writes:
> > Select 134987 * interval '1 msec';
> > ERROR: invalid input syntax for type interval: "1 msec"
>
> > SELECT version();
> >
"Conlon, Joseph F SIK" <[EMAIL PROTECTED]> writes:
> Does anyone think this is the correct behavior?
If you don't think so, you need to change to C locale.
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your su
Does anyone think this is the correct behavior?
adaps_db=# select * from upc_usage order by 1 ;
usage
--
53E
ABC
CYPHER
_GENERAL
H66
HAWK
_JOE
RSRA
S61
S65
S70
S76
S92
XWING
(14 rows)
It appears to be ignoring the underscore!
Database has LATIN1 encoding and was recently
I'm sorry if this is has been discussed, but I tried to find the answer
in the archives and failed, so...
How do I find all the rows in other tables that reference a specific row
in another table? I'm only trying to find rows that are in tables where
there is a Foreign Key referencing the pri
[EMAIL PROTECTED] (Adrian Klaver) writes:
> Select 134987 * interval '1 msec';
> ERROR: invalid input syntax for type interval: "1 msec"
> SELECT version();
> version
>
-- Original message --
From: Tom Lane <[EMAIL PROTECTED]>
> [EMAIL PROTECTED] (Adrian Klaver) writes:
> > select ('134987'::int/1000.00) * interval ' 1 second' ;
> > ?column?
> > --
> > 00:02:14.987
> > (1 row)
>
> Or even easier:
>
> regres
-- Original message --
From: Tom Lane <[EMAIL PROTECTED]>
> [EMAIL PROTECTED] (Adrian Klaver) writes:
> > select ('134987'::int/1000.00) * interval ' 1 second' ;
> > ?column?
> > --
> > 00:02:14.987
> > (1 row)
>
> Or even easier:
>
> regressi
[EMAIL PROTECTED] (Adrian Klaver) writes:
> select ('134987'::int/1000.00) * interval ' 1 second' ;
> ?column?
> --
> 00:02:14.987
> (1 row)
Or even easier:
regression=# select 134987 * interval '1 msec';
?column?
--
00:02:14.987
(1 row)
-- Forwarded Message: --
From: [EMAIL PROTECTED] (Adrian Klaver)
To: Shawn <[EMAIL PROTECTED]>
Subject: Re: [SQL] Part 1 of several - Converting a varchar to an interval
Date: Wed, 26 Mar 2008 16:16:58 +
>
>
>
>
> -- Original message ---
Awesome Adrian!
Thanks! Just what I needed.
On Wednesday 26 March 2008 16:24:34 you wrote:
> -- Original message --
> From: Shawn <[EMAIL PROTECTED]>
>
> > Hello!
> >
> > The second part of my question is:
> >
> > Given a value as an interval, see previous p
-- Forwarded Message: --
From: [EMAIL PROTECTED] (Adrian Klaver)
To: Shawn <[EMAIL PROTECTED]>
Subject: Re: [SQL] Question 2 Interval and timestamptz
Date: Wed, 26 Mar 2008 16:24:39 +
>
> -- Original message --
> From: Shawn <[EMAIL PRO
On Wednesday 26 March 2008 16:16:57 you wrote:
> select ('134987'::int/1000.00) * interval ' 1 second' ;
> ?column?
> --
> 00:02:14.987
> (1 row)
Thanks Adrian!
Wow!
Shawn
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
h
Shavonne Marietta Wijesinghe wrote:
Hello
I have a db in MS Access 97 and now i have to import the data in
PostgreSQL. I can create the table structure in PostgreSql but in
what format can i export the table from Access so Postgresql can read
it?
csv would be the most common and easiest.
Basi
On Wednesday 26 March 2008 11:46:43 Shavonne Marietta Wijesinghe wrote:
> Hello
>
> I have a db in MS Access 97 and now i have to import the data in
> PostgreSQL. I can create the table structure in PostgreSql but in what
> format can i export the table from Access so Postgresql can read it?
>
> Th
Hello!
The second part of my question is:
Given a value as an interval, see previous posting, is there a simply method
to take a given timestamptz value and a given interval value and create the
sum or difference of the 2 in timestamptz format?
The scenario is that the afore mentioned tables,
Hello,
I have several large tables, over 100 million records each. One of the fields
is callee 'duration'. It is a varchar that contains what is essentially an
integer that is the duration of an event in milleseconds. Could someone tell
me a simple way to convert a value such as 134987 store
Hello
I have a db in MS Access 97 and now i have to import the data in PostgreSQL. I
can create the table structure in PostgreSql but in what format can i export
the table from Access so Postgresql can read it?
Thanks
Shavonne
23 matches
Mail list logo
