Hi,
Apologies if this is the wrong list for this question, I
hope it’s not.
I’m porting an application to PostgreSQL, and
rewriting a number of transforms used to convert incoming Excel data into a
final Postgres table schema for an application. Most of it’s gone
okay, but there’s
Kieran Ashley wrote:
Some of our data comes in in a format which provides us with extra
information, but which we currently don't need to use; specifically
we sometimes receive information in the form of calculations, for
example a column which needs to be transformed to an integer is
initially of
On Fri, Jan 07, 2005 at 11:52:07AM -0500, Rick Schumeyer wrote:
> I have a table where I want everyone to be able to be able to insert
> and select.
> But they should only be able to update and delete rows that they
> "own". The table has a column indicating the owner.
> What is the best way to
On Tue, Jan 11, 2005 at 08:38:21AM -0500, rpeterso wrote:
> CREATE RULE lock_test_user_update
> AS ON UPDATE TO test
> WHERE old.aname = CURRENT_USER
> DO INSTEAD nothing;
>
> CREATE RULE lock_test_user_delete
> AS ON DELETE TO test
> WHERE old.aname = CURRENT_USER
> DO INSTEAD nothing;
For your
Thanks for your help Richard,
I tried a number of Pl/SQL approaches, but couldn't get through the
type-checking. I finally knocked out a little PL/TCL script that seems to get
the job done:
create function eval_sums(varchar(8000)) returns integer as '
if {[argisnull 1]} { return_null }
ret
Hi,
with what constraint or how can I ensure that one of my tables has exact one
record or 0..1 records?
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
How are you getting the data from Excel? Perhaps you could use Excel's own
methods to evaluate the cell contents? You may still need to do something
for literal text values (e.g. 'NULL'), though.
"Kieran Ashley" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi,
Apologies if th
I suppose you could put a check constraint that forces a single value on a
column with a unique index? Or an insert trigger that always inserts the same
value into a unique field.
Out of curiosity, why do you need to do this?
Dmitri
-Original Message-
From: [EMAIL PROTECTED] [mailto:[
Also I thought of an UNIQUE constraint on a column with =const constraint.
But
It's for global configuration data that exists only once.
Making a key value thing was to weak typed for my taste.
> -Original Message-
> From: Dmitri Bichko [mailto:[EMAIL PROTECTED]
> Sent: Dienstag, 11
Hello:
I'm trying to figure out how to convert a floating point value into an
interval of time. I'm calculating the time required to drive from point A to
point B. For the sake of this question, we'll just say it is miles/speed. So:
drv_time = 478 / 45.0;
The value of this is: 10.6
I figured it out. This works:
travel_window INTERVAL;
drv_time FLOAT;
drv_time = miles / 45.0;-- drive time
travel_window = quote_literal(drv_time || '' hours'');
The variable, travel_window becomes: @ 10 hours 50 mins 40 secs, which is
what I wanted.
If anybody knows any othe
On Tue, Jan 11, 2005 at 04:42:21PM -0500, Terry Lee Tucker wrote:
> Subject: [SQL] Simple Question
Please use a more descriptive subject -- think about how somebody
looking at a list of 200 messages, all with subjects like "Simple
Question" or "PostgreSQL Question," would decide to look at yours.
Convert to seconds first (3600 sec/hr) :
select (
'3600'::int4
* '478'::int4
/ '45.0'::float8
)::int4::reltime::interval ;
interval
--
10:37:20
(1 row)
I don't know if "::int4::reltime::interval" is the best
way to end up with an interval, but its the only way I
could figure out
On Tue, 11 Jan 2005, Terry Lee Tucker wrote:
> Hello:
>
> I'm trying to figure out how to convert a floating point value into an
> interval of time. I'm calculating the time required to drive from point A to
> point B. For the sake of this question, we'll just say it is miles/speed. So:
>
> drv_t
Thank you for the reply in spite of the subject.
On Tuesday 11 January 2005 05:15 pm, Michael Fuhr saith:
> On Tue, Jan 11, 2005 at 04:42:21PM -0500, Terry Lee Tucker wrote:
> > Subject: [SQL] Simple Question
>
> Please use a more descriptive subject -- think about how somebody
> looking at a list
Thanks for the reply. My answer was a little different than yours because I
used 488 instead of 478. Well, that three ways so far ;o)
On Tuesday 11 January 2005 05:06 pm, Guy Fraser saith:
> Convert to seconds first (3600 sec/hr) :
>
> select (
> '3600'::int4
> * '478'::int4
> / '45.0'::float8
Terry Lee Tucker <[EMAIL PROTECTED]> writes:
> I'm trying to figure out how to convert a floating point value into an
> interval of time.
Use something like
regression=# select (478 / 45.0) * '1 hour'::interval;
?column?
--
10:37:20
(1 row)
... or whatever other scale factor you have
On Tuesday 11 January 2005 17:45, KÖPFERL Robert wrote:
> Hi,
>
> with what constraint or how can I ensure that one of my tables has exact
> one record or 0..1 records?
A trigger procedure BEFORE INSERT would help you.
And a column type with only one possible field value would help you if you
de
18 matches
Mail list logo
