From: Neil Stlyz <neilstylz@yahoo.com>
To: pgsql-novice@postgresql.org
To: pgsql-general@postgresql.org
To: pgsql-sql@postgresql.org
Subject: string functions and operators
Date: Mon, 22 Mar 2010 18:20:57 -0700 (PDT)
Message-ID: <22285.35517.qm@web113713.mail.gq1.yahoo.com> (raw)
Hello,
I have a dilema and I was hoping someone here may offer guidance or assistance. I bet this is a very simple question for someone out there but I am having problems coming up with a solution. Here it is...
suppose I have a field with the following values:
77.1
77.2
134.1
134.2
134.3
5.1
5.2
I need two seperate SELECT queries. One would return the following values (everything left of the decimal point)
77
77
134
134
5
5
The second query would return all of the values to the right of the decimal point:
1
2
1
2
3
1
2
Now, I have been using the following information (although very Greek) to try to solve this problem:
http://www.postgresql.org/docs/current/static/functions-string.html
And I have been playing around with the syntax of the following:
substring('112.5' from '%#"___.#"_' for '#')
but the aforementioned is not quite working out... can someone please show me a string function that will produce the desired results?
Thanks!
~n
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: neilstylz@yahoo.com, pgsql-novice@postgresql.org, pgsql-general@postgresql.org
Subject: Re: string functions and operators
In-Reply-To: <22285.35517.qm@web113713.mail.gq1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox