Guillaume,
> we're looking for a SQL database schema for bibliographical references.
> the goal is to extract all the bibliographical references contained in
> our various existing pgsql scientific databases in only one specific
> database and to interconnect them with external keys and perl scrip
On Mon, 2004-10-18 at 17:28, beyaNet wrote:
> Hi,
> to those of you that may be using the above named admin tool, any ideas
> why I am unable to login with the postgres username even though I have
> amended the pg_hb file?
How have you amended pg_hba.conf? did you send SIGHUP to the postmaster
a
Never mind, it requires on each side of the variable.
Thanks
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Kent Anderson
Sent: Monday, October 18, 2004 1:32 PM
To: [EMAIL PROTECTED] Org
Subject: Re: [SQL] Ordering a record returned from a stored p
I have the code working except for the date part of the where clause. Can
anyone point out how
yield_date = 10/18/2004
can be translated so the 10/18/2004 is coming from a variable?
ie yield_date = '' ... variable with date
Thanks
This works but the date is hardcoded.
FOR result IN
EXEC
I really like pgadmin3: http://www.pgadmin.org
Rick
beyaNet
sreejith s wrote:
How to take Database backup from an application developed in Visual
Basic thats running at Windows Client and Database resting at Linux
Server. THanx
You wrote a similar question some days ago and mentioned that pg_dump
wouldn't work on Windows, so I figure you don't want to l
Hi,
to those of you that may be using the above named admin tool, any ideas
why I am unable to login with the postgres username even though I have
amended the pg_hb file? Are there any other admin tools out there that
i could use on a a unix box?
many thanks
Andrew
---(e
On Mon, 18 Oct 2004, Kent Anderson wrote:
> I am pulling a report from the database using a stored procedure but cannot
> get the information to return in a specific order unless I hardcode the
> order by clause.
>
> CREATE OR REPLACE FUNCTION submissionreport(INTEGER, DATE, TEXT) RETURNS
> setof
I am pulling a
report from the database using a stored procedure but cannot get the information
to return in a specific order unless I hardcode the order by clause.
CREATE OR REPLACE
FUNCTION submissionreport(INTEGER, DATE, TEXT) RETURNS setof submissionrec AS
'DECLARE
r
On Mon, Oct 18, 2004 at 11:24:33 -0400,
David Siegal <[EMAIL PROTECTED]> wrote:
>
> My problem is I don't see how to make aggregated_concat accept an
> optional delimiter argument.
> Maybe it's not possible?
>
> Any ideas?
> Is there some completely different approach I should consider for
> co
I would like to create an aggregate function that returns a concatenation
of grouped values. It would be particularly useful if I could pass an
optional delimiter into the aggregate function.
For example:
With a table, 'team'...
team_numbermember_name
--
1
hello
we're looking for a SQL database schema for bibliographical references.
the goal is to extract all the bibliographical references contained in
our various existing pgsql scientific databases in only one specific
database and to interconnect them with external keys and perl scripts.
databas
a1: Not 100% sure waht you are looing for. Try adding "/qb" and see if
that is what you meant :-)
a2: That exact commandline may not be supported. But we intend to
support commandline-driven silent installs, yes.
a3: See the installer FAQ on http://pginstaller.projects.postgresql.org.
a4: Yes
Title: Message
Fundamentally if the user wants to run my software then I want to
get it running on their hardware. If after they have tried it ( and hopefully
liked it) they want to use it as a business tool then I am in a position to
HIGHLY recommend the necessary upgrades to hardware/OS et
14 matches
Mail list logo
