I want to use PostgreSQL on a project that will have to run on
both Linux and Windows. But using cygwin is not a viable option.
Does the dbExpert version of PostgreSQL run natively under Windows?
Thanks in advance!
John
---(end of broadcast)--
I'll have a look at that; thank you very much for taking the time to reply. :)
Ben
On Mon, 16 Feb 2004 22:03:22 -0800, Greg Patnude wrote:
> You might have better success with the form of HAVING and appropriate use of
> OR IS NULL as opposed to strict JOIN and WHERE conditions...
>
> Similar t
Hello to all,
I have small problem. I have some database fields (VARCHAR)
and these field should hold some ahex coded values. So the
string length must be even and each character can only be
0-9, a-f or A-F.
My idea was that:
8<---
CREATE TABLE test (
You might have better success with the form of HAVING and appropriate use of
OR IS NULL as opposed to strict JOIN and WHERE conditions...
Similar to...
SELECT A.a, B.b, C.c FROM A, B, C
HAVING (A.b = B.b OR B.b IS NULL)
GROUP BY A.b;
--
Greg Patnude / The Digital Demention
2916 East Upper Hay
I received the following note on another database-oriented list.
This may be something that pg users could help in, though I'll also
pass on the caveat that the other list had, that I have no direct knowledge
about the institution or the researchers.
--
Mike Nolan
--
I have a bit of a dilemma, I'm fairly new to PG, and not quite sure how
to do this:
I have a DB that has been basically 'forked' - a copy of the original
was made for a handful of users to play with without messing with the
live DB. Now, they would like to know if the changes they have made to
the
Could you please tell me where I would find the GPG MD5 Checksum values
for the postgres 7.4?
Thank you.
--
Simone L. Crider
Systems Administrator
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Table A has a CHECK constraint testing boolean function F.
Function F has a SELECT from Table A.
In my manual build script, I create the table, then the function, and then at the very
end of the script to I do an ALTER TABLE ADD CHECK.
pg_dump appears to put the CHECK constraint as a clause in t
On Tue, 17 Feb 2004, Ben wrote:
> On Tue, 17 Feb 2004, Oleg Bartunov wrote:
>
> > If ispell dictionary recognizes a word, that word will not pass to en_stem.
> > We know how to add "query spelling feature" to tsearch2, just waiting
> > for sponsorships :) meanwhile, you could use our trgm module,
On Tue, 17 Feb 2004, Oleg Bartunov wrote:
> If ispell dictionary recognizes a word, that word will not pass to en_stem.
> We know how to add "query spelling feature" to tsearch2, just waiting
> for sponsorships :) meanwhile, you could use our trgm module, which
> implements trigram based spelling
On Tue, 17 Feb 2004, Tom Lane wrote:
> Brendan Jurd <[EMAIL PROTECTED]> writes:
> > I'm not objecting to the incompatibility itself, but I do think more
> > information needs to be provided to the user. I humbly suggest that if
> > psql is not going to be fully backwards-compatible with previou
On Tue, 17 Feb 2004, Ben wrote:
> On Tue, 2004-02-17 at 03:15, Oleg Bartunov wrote:
>
> > Do you want '100' or 'hundred' will be fully equivalent ? So,
> > if you search '100' you will find document with 'hundred'. Interesting,
> > that you will find '123', because '123' will be 'one hundred twent
Vidyasagara Guntaka wrote:
> Hi,
>
> I'm new to this list. I'm Sagar. Our company is seriously
> considering using Postgresql for our storage virtualization
> solution. To be able to use the database, replication is must
> for us. At least master-single slave. Synchronous replication
> is pref
Tom Lane wrote:
Brendan Jurd <[EMAIL PROTECTED]> writes:
I'm not objecting to the incompatibility itself, but I do think more
information needs to be provided to the user. I humbly suggest that if
psql is not going to be fully backwards-compatible with previous
postgres backends, at the v
> This has been discussed before. I think the reason for not doing it
> has been the difficulty of coming up with a useful warning that explains
> what will work and what won't.
I think all that is necessary is to expand the startup banner to show
what the back end is:
Welcome to psql 7.4.
Antonios Christofides <[EMAIL PROTECTED]> writes:
> In PostgreSQL there are actually up to THREE users active, not two:
> - The user who connected, which I shall call "connected user".
> - The user who became effective as the result of "alter session
> authorization" command. This is the us
On Tuesday 17 February 2004 12:37, Wei Wang wrote:
> In that case, how do I RAISE NOTICE a text variable such as:
> DECLARE tempstring text;
> BEGIN
> RAISE NOTICE tempstring;
RAISE NOTICE ''%'',tempstring;
Don't forget to double-up (or bacslash-escape) your quotes.
--
Richard Huxton
Archon
On Feb 12, 2004, at 12:08 PM, Bruce Momjian wrote:
Yes, I think that would be the only way to go, but I would like to have
some other folks interested in extending the ps display before adding
such a capability.
Too bad nobody responded. I still think it would be a useful feature.
eric
Brendan Jurd <[EMAIL PROTECTED]> writes:
> I'm not objecting to the incompatibility itself, but I do think more
> information needs to be provided to the user. I humbly suggest that if
> psql is not going to be fully backwards-compatible with previous
> postgres backends, at the very least you
On Tue, Feb 17, 2004 at 13:02:43 +0100,
Holger Marzen <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> if I have something like this:
>
> SELECT column1,
>(... complicated subselect ...),
>column1 - (... same subselect as above ...)
> FROM table1;
>
> do I really have to rewrite the su
unsubscribe
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
unsubscribe
EDMUND ZYNDA
[EMAIL PROTECTED]
FocalBase Internet Solutions
p.
410.751.2093 x219
f.
410.751.2653
www.focalbase.com
<>
Thanks. I was kind of suspecting that. But it's nice to have it
confirmed.
I might try a random delay on the client side after receiving the
notification, before I query. That may help to break up the load on the
server.
On Feb 16, 2004, at 10:27 AM, Mikhail Terekhov wrote:
I'd say it is relat
Yes, my client receives the notification and then it immediately
executes a query that hangs for a while.
On Feb 15, 2004, at 12:07 PM, Tom Lane wrote:
Hmm. Are you certain that the clients have received the NOTIFY?
Perhaps the bottleneck is in delivering the NOTIFY messages, not in
executing th
temporary tables work. Save the complicated
subselect in temporary table, following
queries just simple select on temp table.
Holger Marzen wrote:
Hi all,
if I have something like this:
SELECT column1,
(... complicated subselect ...),
column1 - (... same subselect as above ...)
FRO
In that case, how do I RAISE NOTICE a text variable such as:
DECLARE tempstring text;
BEGIN
RAISE NOTICE tempstring;
END
- Original Message -
From: "Richard Huxton" <[EMAIL PROTECTED]>
To: "Wei Wang" <[EMAIL PROTECTED]>; "pgsql" <[EMAIL PROTECTED]>
Sent: Monday, February 16, 2004 8:24 PM
Depend in the exact query, you can do:
SELECT column1, x.c, column1-x.c
FROM table1, (... complicated subselect ...) as x;
The above may not work if they're correlated, so you can try:
SELECT column1, column2, column1-column2
FROM
(SELECT column1, (... complicated subselect ...) as column2
Hi all,
if I have something like this:
SELECT column1,
(... complicated subselect ...),
column1 - (... same subselect as above ...)
FROM table1;
do I really have to rewrite the subselect a 2nd time if I need that
result in another column's expression?
---(e
Hi,
I'm trying to return a RECORD from a function, but when I try to use the
variable I have the following error:
ERROR: record "r" has no field "id"
Here's an example:
CREATE OR REPLACE FUNCTION test()
RETURNS CHARACTER VARYING AS '
DECLARE r RECORD;
BEGIN
SELECT INTO r get_id(''mytable''
Ok, I found the solution :-D
In the function test(), instead of:
SELECT INTO r get_id(''mytable'');
The following must be done:
SELECT INTO r * FROM get_id(''mytable'') AS (id INT, name VARCHAR(50));
/!\ the datatypes must be EXACTLY the same.
For example, specifying CHARACTER VARYING or even VARC
On Mon, 16 Feb 2004, Ben wrote:
> So I noticed. ;) The dictionary's working, and I'd be happy to expand
> upon the documentation. Just point me at something to work on.
>
I think you may just write a paper "How I did custom dictionary for tsearch2".
>From what I've read I see your dictionary coul
Hi,
I have two tables and I want to get summary
information from the second table for each row of the first table, I can see two
ways to do this one is with the SQL below but since the first table is very big
the group by takes a long time and there is no need since it is unique.
The seco
32 matches
Mail list logo
