Hi Tom
I found a datatype called 'interval' which seems to separate time from its
unit.
Is that what you were thinking of??
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Sunday, January
Hi Folks
I have a column for date which defaults to the
ambigous 2005-1-1 format.
The documantation indicates how to change this to
the unambigous Jan 1 2005, but the instructions aren't clear to me.
Any help will be appreciated.
Bob Pawley
Perhaps you have a solution??
Bob
- Original Message -
From: Scott Marlowe [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Wednesday, January 18, 2006 10:03 AM
Subject: Re: [GENERAL] Dates
On Wed, 2006-01-18 at 12:00, Bob Pawley
Michael
That worked fine.
Thanks for the help. Could you point me to some documentation on the use of
parentheses? Perhaps something that describes what action the parentheses
accomplishes?
Bob
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bob Pawley [EMAIL
Thanks Michael
Bob
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgre General pgsql-general@postgresql.org
Sent: Sunday, December 18, 2005 4:49 PM
Subject: Re: [GENERAL] Views
On Sun, Dec 18, 2005 at 02:52:23PM -0800, Bob Pawley
I have a table, Devices, with various values under the column
Type.
I wish to view all of the information regarding two of these values
'monitor' and 'valve'.
The following gives me the information, but the rows are
duplicatedfrom oneto three times. I would like to seeone row
for each of
Are there any practical limits to the number of functions and triggers that
can be applied to any particular table??
Bob
Yes I am trying to insert all valves into the same row as their associated
mon.
Bob
- Original Message -
From: Jim C. Nasby [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Guy Rouillier [EMAIL PROTECTED]; PostgreSQL General
pgsql-general@postgresql.org
Sent: Monday, November
Thank you I'll give it a try.
Bob
- Original Message -
From: Jim C. Nasby [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Guy Rouillier [EMAIL PROTECTED]; PostgreSQL General
pgsql-general@postgresql.org
Sent: Monday, November 28, 2005 4:13 PM
Subject: Re: [GENERAL] Group
@postgresql.org
Sent: Wednesday, November 23, 2005 2:17 PM
Subject: Re: [GENERAL] Group By?
Bob Pawley wrote:
Bruno
The table I previously sent came through distorted and probabley
caused misunderstanding.
The table control and auto_control are both permanent table. I want to
reshuffle how the information
Auto_control
loop_id
mon
valve_a
valve_b
serial
int4
int4
int4
1
1
3
5
2
2
4
- Original Message -
From: Bruno Wolff III [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Guy
I want to take the serial ID of several values in different rows in one
table and insert them into a single row of another table.
Would the 'group by' command be the best way to do this?
Bob
your message to plain text as preferred on most mailing lists.
Bob Pawley wrote:
I want to take the serial ID of several values in different rows in
one table and insert them into a single row of another table.
Would the 'group by' command be the best way to do this?
Could you provide an actual
Hope someone can help me learn.
Sample 1 below, does work. It transfersevery serial number generated
by table pr into table pi with no duplication.
Sample 2 below, does not work. From a logical (perhaps naive) extension of
Sample 1, I adapted the function to identify which of the serial
No - I mean when each row of pr (contain) has 'ip' inserted as a value or
data.
Bob
- Original Message -
From: Alban Hertroys [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgres General pgsql-general@postgresql.org
Sent: Tuesday, November 15, 2005 9:42 AM
Subject: Re
Thank you.
What clause is acceptable??
Bob
- Original Message -
From: Jaime Casanova [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgre General pgsql-general@postgresql.org
Sent: Tuesday, November 15, 2005 9:55 AM
Subject: Re: [GENERAL] Is it databases in general, SQL
Anderson [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgre General pgsql-general@postgresql.org
Sent: Tuesday, November 15, 2005 10:00 AM
Subject: Re: [GENERAL] Is it databases in general, SQL or Postgresql?
Bob Pawley wrote:
Hope someone can help me learn.
I highly suggest getting
That works. Thanks very much.
Bob
- Original Message -
From: Jaime Casanova [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Alban Hertroys [EMAIL PROTECTED]; Postgres General
pgsql-general@postgresql.org
Sent: Tuesday, November 15, 2005 11:36 AM
Subject: Re: [GENERAL
It worked - Thank you
Bob
- Original Message -
From: William Yu [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Tuesday, November 15, 2005 11:06 AM
Subject: Re: [GENERAL] Is it databases in general, SQL or Postgresql?
Bob Pawley wrote:
Thank you.
What clause is acceptable
I have the following_expression_ working in that the process.fluid_id
is transfereed to pipe.fluid_id when the column - process.contain has a value of
'ip'.
There is no transfer when the contain column holds other values. Success -
so far.
How do I keep the table pipe from being populated
Uwe
In attempting to understand the underlying intent of the statement, I have a
question.
What purpose does the statement myrow serve in this expression.
Bob
- Original Message -
From: Uwe C. Schroeder [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: pgsql-general
I am attempting to transferthe data in thefluid_id
columnof table process into columnfluid_id of table pipe.
This should happenonly whencolumn contain of table
processholds the value 'ip'.
Here is the command that I am having trouble with.
---
create table process (fluid_id
integer
Thank you - what is the correct command???
Bob
- Original Message -
From: Uwe C. Schroeder [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Cc: Bob Pawley [EMAIL PROTECTED]
Sent: Thursday, November 10, 2005 3:34 PM
Subject: Re: [GENERAL] Where
SELECT INTO
tries to create
By 'one record' do you mean one full row or one column of one row??
Bob
- Original Message -
From: Uwe C. Schroeder [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Thursday, November 10, 2005 5:05 PM
Subject: Re: [GENERAL] Where
Thanks again.
I'll give it a try.
Bob
- Original Message -
From: Uwe C. Schroeder [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Thursday, November 10, 2005 7:44 PM
Subject: Re: [GENERAL] Where
one full row - NOT two or more rows
The followingtransfers the serial number of fluid_id into the two
tables, specification and pipe.
However, it doesn't follow the WHERE instruction. Allfluid_id serial
numbers in process are transferred to fluid_id column in pipe with no
discrimination.
I can't see what I have done wrong.
instead.
CONTEXT: PL/pgSQL function "base" line 4 at SQL
statement
I would very much appreciate any
help as to where I am going wrong.
Thanks
Bob
Pawley
.
Thanks again.
Bob Pawley
I have created the following
tables.
First Table -
CREATE TABLE
process
(
process_name varchar(60) NOT
NULL,
fluid_id serial NOT NULL,
fluid varchar(30) NOT
NULL,
ip_op_reactor varchar(3),
source varchar(30),
destination varchar(30),
CONSTRAINT process_pk PRIMARY KEY
(fluid_id)
I am running version 8 on Windows.
Why do I get error messages stating that functions and/or tables do not
exist when these tables and functions are visible, accessible and very much do
exist, as called?
Bob Pawley
I am attempting to create a new trigger through the "new Trigger" interface
on version 8 installed on Windows.
The following is the sql that the interface generates
CREATE TRIGGER trig1 AFTER INSERT ON process FOR EACH
ROW EXECUTE PROCEDURE base(int4);COMMENT ON TRIGGER trig1 ON
process IS
]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgre General pgsql-general@postgresql.org
Sent: Wednesday, October 26, 2005 2:23 PM
Subject: Re: [GENERAL] Error Message
Bob Pawley [EMAIL PROTECTED] writes:
The function name is listed under Functions as - base(int4)
Trigger functions cannot take any
I have a base table called process. Each row of this table is anchored by
a serial column labeled fluid_id.
After data has been entered into a row in process, I want to trigger a
row in another table labeled specification also with a column labeled
fluid_id. I would like this number from
appreciate it.
Bob Pawley
[EMAIL PROTECTED]
, including one specifically for Postgres.
WhatI don't have is the language to look this function up.
Concepts like JOIN appear to used to create views not new rows on other
tables.
Help will be appreciated.
Bob Pawley
Postgresql book or through the
Postgre on-line help.
Thanks
Bob Pawley
Language reflects the character of those who use it.
In this case, the language used also reflects on the community to which it
is directed.
I don't wish to be associated with a professional community, such as
Postgre, that holds such shallow values.
Bob Pawley
- Original Message
In the Postgre documentation I could find ODBC references only to Postgre
7.2 and older.
Can anyone point me to ODBC documentation for version 8?
Bob Pawley
I am new to databases and would like togain some idea of the sizes of
a typical singal database.
For instancewhat are the number of schemas, tables and views
that would constitute a databse considered to be small, medium or large?
Bob Pawley
an account and password but this is rejected
by a message "the account already exists". Further changing the account names in
the interface does not work.
Can someone direct me to the register that needs cleaning??
Bob Pawley
a server to access the database?
If so, what properties do I enter into the add server interface toadd
aserver? Everything I've tried so far has been rejected.
Bob Pawley
301 - 341 of 341 matches
Mail list logo