; [EMAIL PROTECTED]
>
/****.
# Indraneel Majumdar ¡ E-mail: [EMAIL PROTECTED] #
# Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com #
# Centre for DNA Fingerprinting and Diagnostics, #
# Hyderabad, India - 500076 #
`/
the setval?
thanks,
Indraneel
/.
# Indraneel Majumdar ¡ E-mail: [EMAIL PROTECTED] #
# Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com #
# Centre for DNA Fingerprinting and Diagnostics
OK, I solved my own problems (Congrats ;-) Sorry for bothering the list.
This is what I'm doing:
INSERT INTO table SELECT x,x,x where (select count(*) from table where
col1='value')=0;
any suggestions?
thanks,
Indraneel
On Mon, 6 Nov 2000, Indraneel Majumdar wrote:
> N
stgreSQL-7.0.2
Now I have one more problem. How do I insert only once if value does not
exist? eg:
insert into table once select x,x,x where not col1='value'
Thanks,
Indraneel
On Sun, 5 Nov 2000, Cristóvão B. B. Dalla Costa wrote:
> > > insert into table select ... where c
On Sun, 5 Nov 2000, Marten Feldtmann wrote:
> Indraneel Majumdar schrieb:
> >
> > Hi,
> >
> > how can I insert a record after checking whether one of the fields has a
> > certain value or not? eg:
> >
> > if table(col1)='value' in
e) I tried but this
gave an error (so I'm using perl to pass the real tablename for each
query)
Any help will be great,
Indraneel
/****.
# Indraneel Majumdar ¡ E-mail: [EMAIL PROTECTED] #
# Bioinformatics Un
check your pg_hba.conf file for correct permissions. you need to have host
based authenticationenabled for the network/hosts from where you are
trying to connect.
HTH
\Indraneel
On Fri, 3 Nov 2000, Umashankar Kotturu wrote:
> Hi
>
> I am connecting to postgres in a java program r
Is that a small d or a capital D? try this:
postmaster -D $PGDATA2 -i -p 5431 &
\Indraneel
On Thu, 26 Oct 2000, Brian C. Doyle wrote:
> Okay I am still doing something wrong here
>
> I set PGDATA2=/home/user1/database
> export PGDATA2
>
> then I start postmaster
> po
AFAIK the port number is compiled in, so you need to recompile. It's there
in the docs somewhere. you have to use a different value for --with-pgport
option in ./configure .
On Wed, 25 Oct 2000, Brian C. Doyle wrote:
>
> I am still trying to find out how to get multiple postmasters running on
Hi,
Thank you very much. Now I know to use serial and not oid. I hope I got
the correct message.
Thanks,
Indraneel
On Mon, 16 Oct 2000, Josh Berkus wrote:
> Please reference two things:
>
> 1. Look in the list archives for the last 4 weeks and you will read a
> long discussion
? and how can I use
this oid in a select statement?
Thanks,
Indraneel
On Mon, 16 Oct 2000, Gerhard Dieringer wrote:
> I don't know what type of data your columns x and y contain. If they are,
> for example, of type text and contain long strings, then it would be better
> to add an int
Thanks, I too came to the same conclusion (due to lack of
persistence/patience).
Thanks,
Indraneel
On Mon, 16 Oct 2000, Gerhard Dieringer wrote:
> I don't know what type of data your columns x and y contain. If they are,
> for example, of type text and contain long strings, then
database design.
Is it possible to map the columns without repeating values?
\Indraneel
On Mon, 16 Oct 2000, Gerhard Dieringer wrote:
> I'm not sure if I understand your question. Is it right, that the x(i) are different
>values
> of an column x in table T1 and the y(i) are differen
d I cannot increase
overhead by increasing data redundancy.
Is there some way to do something about this?
\Indraneel
/****.
# Indraneel Majumdar ¡ E-mail: [EMAIL PROTECTED] #
# Bioinformatics Unit (EMBNET node), ¡
The example is below:
On Thu, 12 Oct 2000, Jean-Christophe Boggio wrote:
> Hi Indraneel,
>
> IM> I'm converting a complex flatfile where records are arranged serially.
> IM> some fields are as 'n' times repeating blocks of multiple lines. Some
> IM> s
ional arrays, even after I have extended the operators in the
contrib section). Also I cannot put field names for individual columns of
an array.
\Indraneel
On Thu, 12 Oct 2000, Mark Volpe wrote:
> You may want to think about creating your table like this (for example):
>
> CRE
eys the only and best method? Using this
is causing a performance hit. If it's any help, what I'm trying to convert
are biological databases distributed in 'SRS' flatfile format from
ftp.ebi.ac.uk/pub/databases/
Thank you,
Indraneel
/**
Not working, but thanks anyway. Can anyone point out the relevant area of
the source where queries are handled?
Thanks,
Indraneel
On Sun, 24 Sep 2000, Fredrick Bartlett wrote:
> Not sure if same can be accomplished with different servers.
> Try the following for database's on one s
on different machines under
different postmasters. How do I query both simultaneously? Is it possible?
Thanks,
Indraneel
/.
# Indraneel Majumdar ¡ E-mail: [EMAIL PROTECTED] #
# Bioinformatics Unit (EMBNET
Hi,
AFAIK, you can't enter a null value in a bool field, it has to be 1 or 0.
\Indraneel
On Sat, 23 Sep 2000, Jeff MacDonald wrote:
> how would i select all rows where a boolean value is neither
> t nor f.. ?
>
> ie if someone inserted without setting the boolean tag.
&g
3","7","9"}}
I would also like to know that if I have an array as a large object, is it
possible to do a search on it using rows and columns (or by any other
way)?
thanks,
Indraneel
/*
21 matches
Mail list logo
