: [GENERAL] Starting Postgresql
Raymond O'Donnell wrote:
On 20 Dec 2006 at 11:12, Bob Pawley wrote:
which in PostgreSQL is
It's not in PostgreSQL - it's the shell of your operating system. In
Windows, you get that either by clicking Start - Run and typing
command or cmd (depending on your
the libraries can
move with the app per se.
Johann.
Bob Pawley [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I've already built the PostgreSQL database. Now I want to turn it and the
Delphi interface (host) into a distributable application.
I am using Installshield and I need to pick
Thanks Tony
What PostgreSQL files do I use?
Bob
- Original Message -
From: Tony Caduto [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Tuesday, December 19, 2006 8:53 AM
Subject: Re: [GENERAL] Creating an Independant Application
Bob Pawley
What is the best way of installing the tables, triggers etc? Do I add a
project dump file or generate them from an sql file?
Bob
- Original Message -
From: Tony Caduto [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Tuesday, December 19, 2006 9
Hi
I have managed to turn my host software into an executable. It runs well using
my installed database and server.
What files in PostgreSQL do I need to include to have the host software, the
PostgreSQL server and database run as an independant application??
Bob Pawley
I've already built the PostgreSQL database. Now I want to turn it and the
Delphi interface (host) into a distributable application.
I am using Installshield and I need to pick up the files in Postgres to
include.
Bob Pawley
- Original Message -
From: John McCawley [EMAIL PROTECTED
Hi
I want to combine a PostgreSQL project with my host interface software to make
an installable, c/w the PostgreSQL server.
Can someone please point to the document that explains how this is
accomplished??
I am using Delphi's version of InstallShield on Win XP.
Bob Pawley
I would like to learn the basics of PostgreSQL geometric types.
Can someone point to a simple explanation of how it works (preferably within
the PostgreSQL database) how it is being used and any drawing system that would
display the results?
Thanks in advance.
Bob Pawley
To: Bob Pawley
Cc: Postgresql
Sent: Monday, December 11, 2006 10:59 AM
Subject: Re: [GENERAL] Geometric Types
You can use the PostgreSQL docs for that purpose at --
http://www.postgresql.org/docs/8.2/static/functions-geometry.html
For more details you can go through PostGIS (
http
I am receiving an error message about a missing From Clause in an insert
statement.
I've tried a number of variations of adding a from clause with no success.
Could someone help with the following statement??
Insert Into p_id.loop_sequence (monitor) values(p_id.loops.monitor) ;
Bob Pawley
or
serial column.
Dropping and recreating does the job but it can be unstable and requires
either on or two extra tables for each sequence you wish to generate.
Bob
- Original Message -
From: Tony Caduto [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]; pgsql-general@postgresql.org
Perhaps I can - it will be learning curve for me. However, the development
would be so much easier to apply if it were available in PostgreSQL in a
form similar to generating a serial column.
Bob
- Original Message -
From: Alban Hertroys [EMAIL PROTECTED]
To: Bob Pawley [EMAIL
I just installed PostgreSQL 8.1 and PG Admin 1.6.1 .
These versions have a sequential column, that is not part of the table,
identifying the rows.
Is there any method of accessing those numbers and identifying them with
elements within the table??
Bob Pawley
@archonet.com
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Monday, December 04, 2006 9:39 AM
Subject: Re: [GENERAL] PG Admin
Bob Pawley wrote:
I just installed PostgreSQL 8.1 and PG Admin 1.6.1 .
These versions have a sequential column, that is not part
When a row is deleted the serial number and oid are also deleted. The
sequence then has gaps which are inadmissible.
Bob
- Original Message -
From: Tony Caduto [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Monday, December 04, 2006 10:43 AM
- perhaps.
Bob
- Original Message -
From: Raymond O'Donnell [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Monday, December 04, 2006 3:53 PM
Subject: Re: [GENERAL] PG Admin
On 4 Dec 2006 at 15:40, Bob Pawley wrote:
When a row is deleted the serial number and oid are also
-
From: Scott Marlowe [EMAIL PROTECTED]
To: Raymond O'Donnell [EMAIL PROTECTED]
Cc: pgsql general pgsql-general@postgresql.org
Sent: Monday, December 04, 2006 4:09 PM
Subject: Re: [GENERAL] PG Admin
On Mon, 2006-12-04 at 17:53, Raymond O'Donnell wrote:
On 4 Dec 2006 at 15:40, Bob Pawley wrote
, Raymond O'Donnell wrote:
On 4 Dec 2006 at 15:40, Bob Pawley wrote:
When a row is deleted the serial number and oid are also deleted. The
sequence then has gaps which are inadmissible.
This is an issue which has come up at various times on this list in
the past - it may be worth having a look
, is of no consequence - as long as the
totallity of numbers assigned are sequential and gapless.
Bob
- Original Message -
From: Berend Tober [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: pgsql general pgsql-general@postgresql.org
Sent: Monday, December 04, 2006 7:15 PM
Subject: Re
I am installing version 8.1 in Win XP.
Some of the tables I create have the next row displayed, empty, ready for the
next input.
Other tables display only rows with values inserted.
Version 8.0 always displayed the next row.
Is this a characteristic of a difference in 8.1 or am I missing
I have just upgraded from v8.0 to 8.1.
In the new version I keep getting errors due to the absence of 'from' -on
triggers that showed no error in the old version.
Was insisting on the use of from a planned part of the upgrade?
Bob Pawley
and p_id.devices.device_number = library.devices.device_number ;
RETURN NULL;
END;
$$
LANGUAGE 'plpgsql' ;
CREATE TRIGGER loopnumbering AFTER INSERT ON p_id.loops
FOR EACH ROW EXECUTE PROCEDURE p_id.loopnumber();
- Original Message -
From: Jeff Davis [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc
Thanks Jeff
I'm going through a learning curve. I don't need to add possible
instability.
Thanks again.
Bob
- Original Message -
From: Jeff Davis [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Wednesday, November 29, 2006 4:41
I've upgraded from PostgreSQL 8.0 to version 8.1 running on Win XP.
I have an interface developed in Delphi 6 that now won't connect to PostgreSQL.
I get an error connecting to libpq.dll.
Are there any thoughts on where the problem may be - the .dll file, the
connection or Delphi? I am using
I don't know - but it sounds like a good place to start.
Bob
- Original Message -
From: Joshua D. Drake [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Sunday, November 26, 2006 3:17 PM
Subject: Re: [GENERAL] Upgrade
On Sun, 2006
This is the example found in the documentation to dump a database.
Examples
To dump a database:
$ pg_dump mydb db.outThe following - $ pg_dump aurel aurel.out - gives me
ERROR: syntax error at or near $ at character 1What am I missing???Bob
No joy
pg_dump aurel aurel.out
Returns -
ERROR: syntax error at or near pg_dump at character 8
I've had a bit of trouble with the PostgreSQL system if that helps. (access
violation with a reinstall)
Bob
- Original Message -
From: Konrad Neuwirth [EMAIL PROTECTED]
To: Bob Pawley
PostgreSql
Bob Pawley wrote:
My Windows version is 5.1.
Which makes in Windows XP. I believe the net command is available in
all version. I run XP at home and it is there.
My command prompt states that - net or delete - are not recognized as
an
internal or external command.
From the command
?
Bob Pawley
depending on how I start
the prompt) and doesn't recogize the instructions.
Help would be greatly appreciated.
Bob Pawley
update' every row in the Processes table is inserted into
the other tables depending on the conditionals. I end up with multiple inserts
of the same information.
Is it possible to create a trigger that inserts only one row for each entry?
Bob Pawley
I am attempting to distribute the fluid from the process table to its own
table (pipe or equipment) depending on whether the fluid is classified as
op, ip or eq.
I didn't include the after insert trigger as there can't be a trigger until
the ip_op_equipment is updated.
BTW what is TG_OP
What is an example of how geometric datatypes are being
used?
Bob Pawley
PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Saturday, November 04, 2006 5:25 PM
Subject: Re: [GENERAL] Geometric Datatypes
On Sat, Nov 04, 2006 at 05:01:12PM -0800, Bob Pawley wrote:
What is an example of how geometric datatypes are being used
Thanks for the link.
However, I was thinking in terms of how and where the geometric datatypes
are used and why they were developed.
Bob Pawley
- Original Message -
From: A. Kretschmer [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Thursday, November 02, 2006 10:17
Can anyone point me to an overview ofPostgreSQL
geometry?
Bob Pawley
Any thoughts on why dynamically adding a column to a table
would require a run time of 24,000 + milliseconds??
Adding a serial column to three tables requires almost
100,000 ms.
Bob Pawley
Can anyone point me to an overview of PostGIS and how it
is being used???
Bob Pawley
Thanks Jim
Bob
- Original Message -
From:
James Cradock
To: Postgresql
Cc: Bob Pawley
Sent: Thursday, October 19, 2006 8:35
AM
Subject: Re: [GENERAL] PostGIS
On Oct 19, 2006, at 11:08 AM, Bob Pawley wrote:
Can anyone point me to an overview
ach
fluid.
Anyinsight into what is happening will be
appreciated.
Bob Pawley
create or replace function library_spec() returns
trigger as $$beginDeclare
fluid_type varchar ;
BeginSelect fluid into
fluid_typeFrom p_id.specificationsWhere fluid =
new.fluid ;
If fluid_type library.specificat
number. )
Thanks for your comments - everything helps at my stage.
Bob Pawley
- Original Message -
From: Brandon Aiken [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Monday, September 25, 2006 7:47 AM
Subject: Re: [GENERAL] serial column
I would tend to agree with Tom
I need to develop a serial column that always starts at 1
and is sequential evenafter deletes.
Any ideas???
Bob
PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Sunday, September 24, 2006 2:00 PM
Subject: Re: [GENERAL] serial column
On Sun, 2006-09-24 at 13:50 -0700, Bob Pawley wrote:
I need to develop a serial column that always starts at 1 and is
sequential even
Choice a.
I am using the numbers to identify devices.
If a device is deleted or replaced with another type of device I want the
numbering to still be sequential.
Bob
- Original Message -
From: Ragnar [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general
It's the behavior I expect - but the gaps aren't acceptable.
Bob
- Original Message -
From: Gevik Babakhani [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Sunday, September 24, 2006 2:42 PM
Subject: Re: [GENERAL] serial column
Do you have a for instance??
Bob
- Original Message -
From: Ragnar [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Sunday, September 24, 2006 3:10 PM
Subject: Re: [GENERAL] serial column
On sun, 2006-09-24 at 14:29 -0700, Bob
.
Could you point to some documentation for regenerating a column's values
other than manual??
Bob
- Original Message -
From: Gevik Babakhani [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Sunday, September 24, 2006 3:19 PM
Thanks
I'll give that a try.
Bob
- Original Message -
From: Gevik Babakhani [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Sunday, September 24, 2006 4:13 PM
Subject: Re: [GENERAL] serial column
On Sun, 2006-09-24 at 15:29 -0700
@postgresql.org
Cc: Bob Pawley [EMAIL PROTECTED]
Sent: Sunday, September 24, 2006 6:11 PM
Subject: Re: [GENERAL] serial column
On Sunday 24 September 2006 02:29 pm, Bob Pawley wrote:
Choice a.
I am using the numbers to identify devices.
If a device is deleted or replaced with another type of device
numbers without
possibility of a gap.
Perhaps a manually built table is the answer??
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Ragnar [EMAIL PROTECTED]; Postgresql pgsql-general@postgresql.org
Sent: Sunday, September 24, 2006 4:30 PM
I am seeking wording for a procedure that will initiate a
trigger only after another trigger has completed its function. In this case I
want to drop a table that iscreated and usedby the first
trigger.
Could someone point me to documentation?
Bob Pawley
no problem designating the column with the
appropriate letters.
However, I haven't a clue how to add the numerical portion
- or if it is evenpossible.
If anyone has a thought I would appreciate being pointed
to some documentation that covers this.
Bob Pawley
Michael
This works perfectly. Thanks very much for your help.
What is the reason for redefining type_ as device_type ???
Bob
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Friday, August
Michael
Thanks again for your help.
Bob
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Saturday, August 26, 2006 1:36 PM
Subject: Re: [GENERAL] Inserting Data
On Sat, Aug 26, 2006 at 01:22
Michael
OK here goes.
What I am attempting is to break down large categories (devices) into
subcategories (monitor, end-devices, pumps, etc) and enter their device_ids
into their own tables with, in some cases the device_id as that tables primary
key.
The p_id.devices table holds
Michael
You did well interpreting
my scribblings.
In attempting
to use the IF _expression_ (below) I receive an error message stating the return
includes two or more rows. This seems to make sense since I am asking if one
condition exists (p_id device_number = library device_number
correct this action?
Bob
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Tuesday, August 22, 2006 1:58 PM
Subject: Re: [GENERAL] Inserting Data
On Tue, Aug 22, 2006 at 09:02:52AM -0700, Bob
I thought the NEW qualified the select.
If not, how is select qualified??
Thanks
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Michael Fuhr [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Wednesday, August 23
PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Michael Fuhr [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Wednesday, August 23, 2006 3:31 PM
Subject: Re: [GENERAL] Inserting Data
Bob Pawley [EMAIL PROTECTED] writes:
I thought the NEW qualified the select.
Not at all
when I attempt this procedure.
Hence - my problem.
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Michael Fuhr [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Wednesday, August 23, 2006 4:05 PM
Subject: Re: [GENERAL
'
statement that was in my earlier e-mail.
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Michael Fuhr [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Wednesday, August 23, 2006 4:44 PM
Subject: Re: [GENERAL] Inserting Data
the structure as best I can.
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Michael Fuhr [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Wednesday, August 23, 2006 4:44 PM
Subject: Re: [GENERAL] Inserting Data
Bob Pawley [EMAIL
Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Monday, August 21, 2006 4:47 PM
Subject: Re: [GENERAL] Inserting Data
On Mon, Aug 21, 2006 at 08:27:58AM -0700, Bob Pawley wrote:
Yes - Multiple rows of the same data are created in each secondary table.
I have two triggers
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Friday, August 18, 2006 7:27 PM
Subject: Re: [GENERAL] Inserting Data
On Fri, Aug 18, 2006 at 09:27:19AM -0700, Bob Pawley wrote:
I need to insert data
Hi All
I have a basic problem that I hope can be
addressed.
I need to insert data from one table into three other
tables.
I attempted the following format.
CREATE OR REPLACE FUNCTION p_id_monitor()RETURNS
"trigger" AS$$Begininsert into p_id.loops
(monitor) Select p_id.devices.devices_id
Make a table that you can reference. Fill it with Arabic,
English or any language that you wish.
Make it available to the list so those who wish can
particpate and receive a copy of the finished product.
Bob
- Original Message -
From:
Samer
Abukhait
To:
Thanks Tony
I installed PostgresDAC and it cleared up the problem.
Bob
- Original Message -
From: Tony Caduto [EMAIL PROTECTED]
To: Jim C. Nasby [EMAIL PROTECTED]
Cc: Bob Pawley [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Monday, May 22, 2006 1:54 PM
Subject
How can I determine if my tables are 'read only' or
'read/write'?
Bob
someone explain this difference?
Bob Pawley
- Original Message -
From: Bob Pawley [EMAIL PROTECTED]
To: Joshua D. Drake [EMAIL PROTECTED]
Cc: Frank L. Parks [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Wednesday, May 10, 2006 3:55 PM
Subject: Re: [GENERAL] Interface
The folkson the Delphi forum haven't been responsive
to this question. Perhaps the ones that visit the forum don't know the
answer.
I have created a Delphiinterface to a Postgresql
tablecontaining a serial column.
When I try to insert a new value through the interface I
get an error
: Wednesday, May 10, 2006 12:30 PM
Subject: Re: [GENERAL] Interface
Bob,
Can you at least show what your insert statement looks like please?
Also, are you using ODBC or VitaVoom's direct driver for DBExpress?
Frank
Bob Pawley wrote:
The folks on the Delphi forum haven't been responsive
attempting to solve. (Same SQL code)
Lots of challenges for a beginner to work through.
Bob
- Original Message -
From: Joshua D. Drake [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Frank L. Parks [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Wednesday, May 10, 2006
the wrong driver for my version of
Postgresql or is there something in Postgresql that I need toswitch
on???
Bob Pawley
Thanks Tony I found it.
Can you give me a hint as to how to open the file??
Bob
- Original Message -
From: Tony Caduto [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Wednesday, March 29, 2006 8:12 AM
Subject: Re: [GENERAL] Connecting
Bob
considering that
Postrgresql version is a lot newer than Delphi?
If it is possible, can someone point me to a tutorial that
can guide me through the steps. I am new to interspecies
connections?
Is there a better method of making this
comnnection?
Bob Pawley
determine where the problem is - Creator,
Postgresql or me.
Has anyone else experienced difficulty in using these
Postgresql/Java drivers.
Bob Pawley
I am attempting to connect Postgresql (Windows XP, Version
1.2.1 March 28, 2005 (in the PG Admin 3 about ) to Java Studio Creator
2.
Of the four selections presented can someone point to the
driver I should use for PG Version 1.2.1???
Bob
I'll try it.
Thanks for your help.
Bob
- Original Message -
From:
Daniel
Blaisdell
To: Bob Pawley
Cc: Postgresql
Sent: Thursday, March 09, 2006 11:58
AM
Subject: Re: [GENERAL] JDBC
-BEGIN PGP SIGNED MESSAGE-Hash: SHA1I'm
assuming that your real
be ideal.
I am running Postgresql v 8.0 on Windows
XP.
Bob Pawley
Thanks I am using pgadmin for development. I'm looking for a tool with which
I can develop an interface that will be used for entering and accessing
information in context with the user tasks.
Bob
- Original Message -
From: Philippe Ferreira [EMAIL PROTECTED]
To: Bob Pawley [EMAIL
This looks quite interseting.
Thanks Wes
Bob
- Original Message -
From:
Wes Williams
To: 'Bob Pawley' ; 'Postgresql'
Sent: Friday, February 10, 2006 9:14
AM
Subject: RE: [GENERAL] Tool
You may wish to
consider creating a web interface GUI.
For example
Thanks very much Tony.
I'll give it a go.
Bob
- Original Message -
From: Tony Caduto [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Friday, February 10, 2006 11:42 AM
Subject: Re: [GENERAL] Tool
I am developing a database which needs testing prior to
, how do I change the stack depth limit? I
can't find anything in the documentation that describes this task.
I understand the default stack depth is about 2
meg. How do I determine what the stack depth should be so that I avoid this
error?
Bob Pawley
Thanks all
I do think I have a recursive problem. It's just hard to see at the moment.
Bob
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bricklen Anderson [EMAIL PROTECTED]
Cc: Bob Pawley [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Wednesday
Thanks Michael
I'll keep this for future use. I beleive I was using insert into and update
when I should have been using update only.
Bob
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Bricklen Anderson [EMAIL PROTECTED]; Postgresql
) and do the conversion as the data is entered.
Any thoughts on how best to accomplish this task with Postgresql would
be appreciated. (Im on Windows XP)
Bob Pawley
or
more tables contain similar information. But, is it only a perception???
Perhaps there is another way???
Bob Pawley
- Original Message -
From: Michael Glaesemann [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Tuesday, January 31
Message -
From: Michael Glaesemann [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Tuesday, January 31, 2006 5:18 PM
Subject: Re: [GENERAL] Data Conversion
On Feb 1, 2006, at 9:53 , Bob Pawley wrote:
Two way conversion
not be a Postgresql problem as other applications have
'failed' at various times as well (Empire Earth being one).
I would look at Mac or others if I didn't need to develop in Windows.
Bob
- Original Message -
From: Michael Glaesemann [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc
end
(Min, Max, Norm plus a unit column for each).
The downside is that the number of brackets
required increases for each succeeding column for insert and update. The last
column would comprise 48 brackets, 24 before - 24 after.
Is there a work-around for this.
Bob Pawley
create table
---+---+---
Bill | {1,1,1,1} |
{{meeting,lunch},{training,presentation}}
Carol | {2,25000,25000,25000} |
{{breakfast,consulting},{meeting,lunch}}
(2 rows)
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley
- Original Message -
From: Bob Pawley [EMAIL PROTECTED]
To: Karsten Hilbert [EMAIL PROTECTED]
Sent: Thursday, January 26, 2006 11:26 AM
Subject: Re: [GENERAL] Arrays
Because with arrays I can include other information such as pointers to
conversion factors and hopefully implement
ERROR: malformed array literal: {100, 250, 500, DegF)
I want to do single dimension arrays.
How did I turn it into multidmensional?
Bob
- Original Message -
From: Stephan Szabo [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Tom Lane [EMAIL PROTECTED]; Postgresql
pgsql
ERROR: malformed array literal: {100, 250, 500, DegF)
I want to do single dimension arrays.
How did I turn it into multidmensional?
Bob
- Original Message -
From: Stephan Szabo [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Tom Lane [EMAIL PROTECTED]; Postgresql
pgsql
Thank you - my eyes aren't what they used to be.
Bob
- Original Message -
From: Joshua D. Drake [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Stephan Szabo [EMAIL PROTECTED]; Tom Lane
[EMAIL PROTECTED]; Postgresql pgsql-general@postgresql.org
Sent: Thursday, January 26
I missed that - thanks for the help.
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Stephan Szabo [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Thursday, January 26, 2006 12:12 PM
Subject: Re: [GENERAL] Arrays
The order for the array is Min, Norm, Max, Unit.
I'll probably reorder it with the unit first as every value has a unit.
Bob
- Original Message -
From: Tino Wildenhain [EMAIL PROTECTED]
To: Joshua D. Drake [EMAIL PROTECTED]
Cc: Bob Pawley [EMAIL PROTECTED]; Stephan Szabo
[EMAIL
Our application will be dispersed amongst many users.
I want to keep the datbase as generic as possible.
Bob
- Original Message -
From: Tino Wildenhain [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Joshua D. Drake [EMAIL PROTECTED]; Stephan Szabo
[EMAIL PROTECTED]; Tom
Thanks Scott - I'll give this a try.
Bob
- Original Message -
From: Scott Marlowe [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Tino Wildenhain [EMAIL PROTECTED]; Joshua D. Drake
[EMAIL PROTECTED]; Stephan Szabo [EMAIL PROTECTED]; Tom
Lane [EMAIL PROTECTED]; Postgresql
My initial tables have columns containing values
such as 12 feet.
I want to perform calculations.
Is there a method in Postgresql to separate the 12
from the unit feet or am I forced to make two columns to separate the feet from
the 12?
Bob Pawley
201 - 300 of 341 matches
Mail list logo