; [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
ol1 = 'value'
> > >
> >
> > this is working but I am inserting values directly and not by select. eg:
> >
> > insert into table values(x,x,x)
> > and not
> > insert into table select * from table2
> >
>
> insert into table select
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
at running
> postgres). However if I put 127.0.0.1 (or localhost) instead of
> , it resolves and works fine.
>
> Any suggestions on what could be the problem ?
>
> Regards
> Uma.
>
/********.
# In
site. (Chapter 7, I
> believe).
>
/****.
# Indraneel Majumdar ¡ E-mail: [EMAIL PROTECTED] #
# Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com #
# Centre for DNA Fingerprinting and Diagnostics,
;
> --
> Gerhard
>
/****.
# Indraneel Majumdar ¡ E-mail: [EMAIL PROTECTED] #
# Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com #
# Centre for DNA Fingerprinting and Diagnostics, #
# Hyderabad, India - 500076 #
`/
;
> --
> Gerhard
>
/****.
# Indraneel Majumdar ¡ E-mail: [EMAIL PROTECTED] #
# Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com #
# Centre for DNA Fingerprinting and Diagnostics, #
# Hyderabad, India - 500076 #
`/
hope this helps.
>
>
> Gerhard
/********.
# Indraneel Majumdar ¡ E-mail: [EMAIL PROTECTED] #
# Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com #
# Centre for DNA Fingerprinting and Diagnostics, #
# Hyderabad, India - 500076 #
`/
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), ¡
might be to define my own types but then in the end how do I face the
problem that number of entries are variable? Again another array? Or do I
have to use a lot of tables with indexes (which will also be bulky and
slow)?
thanks,
Indraneel
> --
> Jean-Christophe Boggio
> [EMAIL PROTECTED]
>
--
> a| 1 | x
> a| 1 | y
> a| 1 | z
> a| 2 | a
> a| 2 | d
> a| 2 | f
> b| 1 | m
> b| 1 | n
>
>
> I'm not sure what your data looks lik
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
/**
erver, use alias & dot notation...
>
> select a1.colA1 from
> myDatabase1.tableA1 a1
> where a1.A2 in (select b1.colB1 from myDatabase2.tableB1 b1)
>
/****.
# Indraneel Majumdar
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
t;
> Jeff MacDonald,
>
/****.
# Indraneel Majumdar ¡ E-mail: [EMAIL PROTECTED] #
# Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com #
# Centre for DNA Fing
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
/*
19 matches
Mail list logo
