Hi,
Thanks for your reply.
Indeed, why not?
Tena Sakai
tsa...@gallo.ucsf.edu
On 2/3/10 3:38 AM, msi77 ms...@yandex.ru wrote:
Why not to use
select subjectid, height
from tsakai.pheno
where height like '%.%';
?
Hi everybody,
I need a bit of help on postgres reqular expression
Thank you, Dirk.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 2/3/10 11:43 AM, Dirk Jagdmann jagdm...@gmail.com wrote:
Be careful when working with backslashes and regular expressions for
the proper (double) escaping!
# select '70a5' ~ e'\\d+\.\\d+';
?column?
--
t
(1 row
spiral descent...
Please help.
Thank you.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
Thank you kindly, Pavel.
Regards,
Tena Sakai
On 2/2/10 12:38 PM, Pavel Stehule pavel.steh...@gmail.com wrote:
2010/2/2 Tena Sakai tsa...@gallo.ucsf.edu:
Hi everybody,
I need a bit of help on postgres reqular expression.
With a table of the following definition:
Table
(10 rows)
canon=#
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Rob Sargent [mailto:robjsarg...@gmail.com]
Sent: Wed 7/1/2009 9:36 AM
To: Tena Sakai
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] it's not NULL, then what is it?
So they were null, and null turns
Many thanks, Tom.
I wish I had known \pset null nil trick.
It would have saved a few unnecessary emails.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Wed 7/1/2009 10:42 AM
To: Tena Sakai
Cc: Rob Sargent; pgsql-sql
---
67284
(1 row)
My confusion is that if they are real and not null,
what are they? How would I construct a query to do
something like:
select count(maf)
from gallo.sds_seq_reg_shw
where maf ISBLANK;
Thank you in advance.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
: column nan does not exist
LINE 3: where maf = NAN;
^
What can I put to the right of equal sign to make the query work?
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Rob Sargent [mailto:robjsarg...@gmail.com]
Sent: Tue 6/30/2009 3:24 PM
To: Tena
Hi Edward,
Just out of curiosity did you try maf = 0?
Yes, and this is what I get:
canon=# select maf
canon-# from gallo.sds_seq_reg_shw
canon-# where maf = 0;
maf
-
(0 rows)
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: pgsql-sql-ow
Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Steve Crawford [mailto:scrawf...@pinpointresearch.com]
Sent: Tue 6/30/2009 3:39 PM
To: Tena Sakai
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] it's not NULL, then what is it?
...
canon=# select count(maf) from
q
4645647
$
Many thanks, Osvald.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Osvaldo Kussama [mailto:osvaldo.kuss...@gmail.com]
Sent: Tue 6/30/2009 6:49 PM
To: Tena Sakai
Subject: Re: [SQL] it's not NULL, then what is it?
2009/6/30 Tena Sakai tsa
,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Tue 6/30/2009 7:17 PM
To: Tena Sakai
Cc: Edward W. Rouse; pgsql-sql@postgresql.org
Subject: Re: [SQL] it's not NULL, then what is it?
Tena Sakai tsa...@gallo.ucsf.edu writes:
My
?
Thank you for your help.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
Hi Tom,
I am a bit surprised to hear that that '\n'
is there unconditionally. But I am sure
there are more pressing things for you to
work on. It's something I can live with.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent
Hi Andrew,
Right. There's a simple pipeline way to get rid of it:
psql -t -f query.sql | sed -e '$d' query.out
Hi Scott,
Tired of those blank lines in your text files? Grep them away:
psql -tf query.sql mydatabase | grep -v ^$ query.out
Thank you Both.
Regards,
Tena Sakai
tsa
| 2521543
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
Many thanks, Osvaldo.
Regards,
Tena Sakai
-Original Message-
From: Osvaldo Kussama [mailto:osvaldo.kuss...@gmail.com]
Sent: Sun 3/29/2009 10:44 AM
To: Tena Sakai
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] a bit confused about distinct() function
2009/3/29 Tena Sakai tsa
Many thanks, Tom.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Sun 3/29/2009 10:49 AM
To: Tena Sakai
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] a bit confused about distinct() function
Tena Sakai tsa
Hi,
Not to say which is better or worse, I find the use
of lpad() interesting as well:
select problem_id,
lpad (cast(solution_count as varchar), 9, '0')
from problem;
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of novice
Sent
Thank you!
Very educational and started a few wheels turning for
an application.
Would you please comment on enum's sql compatibility
and portability?
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of Michael Lourant
Sent: Tue 5/27/2008 7
Hi,
In a recent linux magazine article (http://www.linux-mag.com/id/5679)
there was a mentioning of Full-Text Search Integration. Which I know
nothing about, but sounded interesting to me. You might want to
check it out.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From
Hi Jonah,
Still, you should UNION the result of
both exceptions into a single result set.
Great suggestion. Many thanks.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Jonah H. Harris [mailto:[EMAIL PROTECTED]
Sent: Thu 3/20/2008 12:21 PM
To: Tena Sakai
Cc: pgsql
--+--+---+-+-
2892473 | 2810329 | t | 2008-03-12 14:37:18.165 | 3000-01-01 12:00:00
(1 row)
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Jonah H. Harris [mailto:[EMAIL PROTECTED]
Sent: Wed 3/19/2008 3:39 PM
To: Tena Sakai
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL
Hi Everybody,
Is there a sql way to compare (in a diff/cmp sense)
2 tables? For example,
create table foo as
[select bla bla bla];
create table moo as
[select bla bla bla];
How would I go about knowing foo and moo are identical
(or not)? Any pointer would be appreciated.
Tena
Fantastic! Many thanks.
Regards,
Tena Sakai
-Original Message-
From: [EMAIL PROTECTED] on behalf of Jonah H. Harris
Sent: Wed 3/19/2008 3:39 PM
To: Tena Sakai
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] compare 2 tables in sql
On Wed, Mar 19, 2008 at 1:56 PM, Tena Sakai [EMAIL
Hi Ed,
I tried exactly what you did and it works for me.
My postgres is 8.3.0 running on redhat advanced
server. This is what it told me:
prompt=# SELECT ('1' || repeat('0', 7))::bit varying;
varbit
--
1000
(1 row)
prompt=#
Regards,
Tena Sakai
[EMAIL PROTECTED
thanks in advance.
Regards,
Tena Sakai
[EMAIL PROTECTED]
| 2007-08-09 00:06:06.742
. .. .
. .. .
I don't understand why it thinks August is greater than
October. Can someone please elucidate what is going on?
Regards,
Tena Sakai
[EMAIL PROTECTED]
Oooops! I got it.
I was missing quotes.
It must have evaluated 2007-10-02 and used it as a
numerical constant 1995.
Sorry about commotion.
Tena
-Original Message-
From: [EMAIL PROTECTED] on behalf of Tena Sakai
Sent: Tue 10/16/2007 10:57 AM
To: pgsql-sql@postgresql.org
Subject: [SQL
is ,.
canon is the name of database, but when I issue a select
command, it still uses '|' as separator. What am I
doing wront?
Regards,
Tena Sakai
[EMAIL PROTECTED]
many thanks, Michael! I appreciate it.
Regards,
Tena
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]
Sent: Wed 10/3/2007 5:54 PM
To: Tena Sakai
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] field separator problem
On Wed, Oct 03, 2007 at 05:13:48PM -0700, Tena
31 matches
Mail list logo