Hi all,
I hope this is useful for people using open office regularly. Can we get this
posted on techdocs?
Regards
Shridhar
Original Message
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Was fooling around a bit and managed to get OpenOffice.org 1.1 and
PostgreSQL to talk
Tom Lane wrote:
Ron St-Pierre <[EMAIL PROTECTED]> writes:
I just want to constrain the ysnDefault field to only allow one TRUE
value for any companyID/associationID pair, with no restrictions on the
number of FALSES.
You could do that with a partial unique index. There is an example
at the bo
Hello list
I hope someone can gave me a hint / advice on this.
I wanted a auto-increasement function, similar to sequence, to increase
a field. I cannot use CREATE SEQUENCE because it cd_line_no will start
again with a new coursedetail.
TQ in advance.
TABLE
=
CREATE TABLE coursedetail
(
cd_
On Sat, Nov 01, 2003 at 10:18:14AM +1300, Mark Kirkwood wrote:
>
> Dave Weaver wrote:
>
> >>- clustering the "obs" table on "station"
> >
> >Sorry, I don't understand what you mean by this - can you explain?
> Supposing obs_pkey is on (station, valid_time):
>
> cluster obs_pkey on obs
Be aware
mlunnon @ RWA wrote:
Thanks for your reply tom. I'm sure it is not a mistype, I included the
definition that I used in my script. Perhaps it is something to do with the
cygwin installation of Postgres that I have i will try it on a Linux box.
The type you were referring to is a composite type:
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> Nope, you are free to do with PostgreSQL (or any derived works) what you
> will ... we are a BSD licensed ... "without fee" means that you can do
> what you like with it *without* having to pay anyone for that right ...
In particular, "without fee"
What a solution!!!
I need to insert the querys in a table
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
---(end of broadcast)-
On Fri, 31 Oct 2003, Neil Zanella wrote:
> Hello,
>
> I would like to ask the about the following...
>
> PostgreSQL allows tables resulting from subselects to be renamed with
> an optional AS keyword whereas Oracle 9 will report an error whenever
> a table is renamed with the AS keyword. Furthermo
[EMAIL PROTECTED] (Neil Zanella) writes:
> PostgreSQL allows tables resulting from subselects to be renamed with
> an optional AS keyword whereas Oracle 9 will report an error whenever
> a table is renamed with the AS keyword. Furthermore, in PostgreSQL
> when the result of a subselect is reference
Neil Zanella writes:
> 1. Does standard SQL allow an optional AS keyword for (re/)naming
>tables including those resulting from subselects.
Yes.
> 2 Why must a subselect whose fields are referenced in an outer query
> be explicitly named in PostgreSQL when it is not necessary in Oracle.
B
On Fri, 31 Oct 2003, Ryan Mack wrote:
> First, I want to confirm my understanding that the "without fee" clause in
> the PostgreSQL license means that a party may not sell PostgreSQL or works
> derived from the PostgreSQL source code.
Nope, you are free to do with PostgreSQL (or any derived wor
Quoting Bruce Momjian <[EMAIL PROTECTED]>:
> [EMAIL PROTECTED] wrote:
> >
> > Perhaps I am not the appropriate one to mention this (and if you
> already
> > have a QA group,GREAT!!!) since I am not a
> > Postgres developer but... Is there any QA group that looks at the
> > design specs and does
First, I want to confirm my understanding that the "without fee" clause in
the PostgreSQL license means that a party may not sell PostgreSQL or works
derived from the PostgreSQL source code.
Second, do loadable PostgreSQL modules constitute a derived work? Can a
party develop new PostgreSQL types
Thanks for your reply tom. I'm sure it is not a mistype, I included the
definition that I used in my script. Perhaps it is something to do with
the cygwin installation of Postgres that I have i will try it on a
Linux box.
Cheers
Matthew
Tom Lane wrote:
"mlunnon @ RWA" <[EMAIL PROTECTED]> w
Hello,
I would like to ask the about the following...
PostgreSQL allows tables resulting from subselects to be renamed with
an optional AS keyword whereas Oracle 9 will report an error whenever
a table is renamed with the AS keyword. Furthermore, in PostgreSQL
when the result of a subselect is re
I want to create a constraint that's a little different, but don't know
how to implement it. I have an intermediate table with a compound PK and
a boolean 'ysnDefault' column:
comanyID INTEGER REFERENCES companies,
assocationID INTEGER REFERENCES associations,
ysnDefault BOOLEAN
I
Ron St-Pierre <[EMAIL PROTECTED]> writes:
> I just want to constrain the ysnDefault field to only allow one TRUE
> value for any companyID/associationID pair, with no restrictions on the
> number of FALSES.
You could do that with a partial unique index. There is an example
at the bottom of
http
On Fri, Oct 17, 2003 at 03:10:03PM +, Edwin Quijada wrote:
> Where can I find examples to accesing postgres with perl.
if you have DBD::Pg and DBI, check out their respective
manpages. that's the easy way to get into postgres from perl.
as far as having perl available from inside postgres, c
Hi!
Normally the PostgreSQL-database files are located in
'/var/lib/postgresql/data'.
HTH,
Simon
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Victor Spång Arthursson
> Sent: Wednesday, October 29, 2003 11:32 AM
> To: pgsql-general
> Subjec
Hi all
Can I make something linke:
IF EXISTS(company_id_seq)
DROP SEQUENCE company_id_seq;
in a DDL where i creates all my tables?
/Henrik
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
20 matches
Mail list logo
