Thank you, Dirk.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 2/3/10 11:43 AM, "Dirk Jagdmann" wrote:
> Be careful when working with backslashes and regular expressions for
> the proper (double) escaping!
>
> # select '70a5' ~ e'\\d+\.\\d+
Hi,
Thanks for your reply.
Indeed, why not?
Tena Sakai
tsa...@gallo.ucsf.edu
On 2/3/10 3:38 AM, "msi77" wrote:
> Why not to use
>
> select subjectid, height
> from tsakai.pheno
> where height like '%.%';
>
> ?
>
>> Hi everybody,
>
Thank you kindly, Pavel.
Regards,
Tena Sakai
On 2/2/10 12:38 PM, "Pavel Stehule" wrote:
> 2010/2/2 Tena Sakai :
>> Hi everybody,
>>
>> I need a bit of help on postgres reqular expression.
>> With a table of the following definition:
>>
&
e.g., E'\r\n'.
From there, it was a downward 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
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;
nil
nil
nil
nil
nil
nil
nil
(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 NU
egards,
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" writes:
>&g
1 row)
$ dc
4578363 67284 + p 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?
20
ards,
Tena 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
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
rom gallo.sds_seq_reg_shw
canon-# where maf = NAN;
ERROR: 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:
;
count
---
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
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
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.
ine?
Thank you for your help.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
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" writ
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 :
>
21543 | 2521543
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
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 n
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/2
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
|datereplaced
--+--+---+-+-
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.
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:
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 <[EM
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
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 Sa
on
[2007-11-14 09:39:22.841 PST] ERROR:
relation "msysconf" does not exist
[2007-11-14 09:39:22.842 PST] STATEMENT: SELECT Config, nValue FROM MSysConf
Many thanks in advance.
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
| 0| 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]
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
non=# \f ','
Field separator 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]
31 matches
Mail list logo
