Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 1E32163241A
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 22 Mar 2010 22:52:06 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 91649-10 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 23 Mar 2010 01:51:55 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.akn.me (mail.akn.me [188.40.171.129])
	by mail.postgresql.org (Postfix) with ESMTP id 547FE632184
	for <pgsql-sql@postgresql.org>; Mon, 22 Mar 2010 22:51:55 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mail.akn.me (Postfix) with ESMTP id 2FCBA4881518;
	Tue, 23 Mar 2010 02:09:28 +0100 (CET)
X-Virus-Scanned: amavisd-new at akn.me
Received: from mail.akn.me ([127.0.0.1])
	by localhost (mail.akn.me [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 8edkodCWKBCo; Tue, 23 Mar 2010 02:09:23 +0100 (CET)
Received: from [127.0.0.1] (213.37.99.4.dyn.user.ono.com [213.37.99.4])
	by mail.akn.me (Postfix) with ESMTP id E774D4881517;
	Tue, 23 Mar 2010 02:09:22 +0100 (CET)
Message-ID: <4BA81E52.9090200@venaver.info>
Date: Tue, 23 Mar 2010 02:50:10 +0100
From: Petru Ghita <petrutz@venaver.info>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.9.1.8) Gecko/20100227 Thunderbird/3.0.3
MIME-Version: 1.0
To: Neil Stlyz <neilstylz@yahoo.com>,
	pgsql-sql mailing list <pgsql-sql@postgresql.org>
Subject: Re: string functions and operators
References: <22285.35517.qm@web113713.mail.gq1.yahoo.com>
In-Reply-To: <22285.35517.qm@web113713.mail.gq1.yahoo.com>
X-Enigmail-Version: 1.0.1
Content-Type: multipart/alternative;
	boundary="------------040405000104070509070304"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5
	tests=BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201003/163
X-Sequence-Number: 33870

This is a multi-part message in MIME format.
--------------040405000104070509070304
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
That field of yours... what type is it?
Is it TEXT? is it a numeric type?
If it's TEXT, why don't you make it say... NUMERIC(/10/, /6///)?

http://www.postgresql.org/docs/8.4/interactive/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL


On 23/03/2010 2:20, Neil Stlyz wrote:
> 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
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
 
iEYEARECAAYFAkuoHlIACgkQt6IL6XzynQTJ/ACfX4mSteAz9CmZLnPCayz+jXQI
IhoAnA7qrFHNmRVObfSvE+YXZ0OKr3MS
=wvB9
-----END PGP SIGNATURE-----


--------------040405000104070509070304
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html; charset=ISO-8859-1"
 http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
-----BEGIN PGP SIGNED MESSAGE----- <br>
Hash: SHA1 <br>
&nbsp;<br>
That field of yours... what type is it?<br>
Is it TEXT? is it a numeric type?<br>
If it's TEXT, why don't you make it say... NUMERIC(/10/, /6///)?<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/8.4/interactive/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL">http://www.postgresql.org/docs/8.4/interactive/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL</a><br>
<br>
<br>
On 23/03/2010 2:20, Neil Stlyz wrote:<br>
<span style="white-space: pre;">&gt; Hello,<br>
&gt; <br>
&gt; I have a dilema and I was hoping someone here may offer guidance<br>
&gt; or assistance. I bet this is a very simple question for someone<br>
&gt; out there but I am having problems coming up with a solution.
Here<br>
&gt; it is...<br>
&gt; <br>
&gt; suppose I have a field with the following values:<br>
&gt; <br>
&gt; 77.1 77.2 134.1 134.2 134.3 5.1 5.2<br>
&gt; <br>
&gt; I need two seperate SELECT queries. One would return the
following <br>
&gt; values (everything left of the decimal point)<br>
&gt; <br>
&gt; 77 77 134 134 5 5<br>
&gt; <br>
&gt; The second query would return all of the values to the right of<br>
&gt; the decimal point:<br>
&gt; <br>
&gt; 1 2 1 2 3 1 2<br>
&gt; <br>
&gt; <br>
&gt; Now, I have been using the following information (although very <br>
&gt; Greek) to try to solve this problem:<br>
&gt; <br>
&gt;
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/current/static/functions-string.html">http://www.postgresql.org/docs/current/static/functions-string.html</a><br>
&gt;<br>
&gt;&nbsp; And I have been playing around with the syntax of the following:<br>
&gt; <br>
&gt; substring('112.5' from '%#"___.#"_' for '#')<br>
&gt; <br>
&gt; but the aforementioned is not quite working out... can someone <br>
&gt; please show me a string function that will produce the desired<br>
&gt; results?<br>
&gt; <br>
&gt; Thanks! ~n<br>
&gt; <br>
&gt; </span><br>
-----BEGIN PGP SIGNATURE-----
<br>
Version: GnuPG v1.4.9 (MingW32)
<br>
Comment: Using GnuPG with Mozilla - <a class="moz-txt-link-freetext" href="http://enigmail.mozdev.org/">http://enigmail.mozdev.org/</a>
<br>
&nbsp;<br>
iEYEARECAAYFAkuoHlIACgkQt6IL6XzynQTJ/ACfX4mSteAz9CmZLnPCayz+jXQI
<br>
IhoAnA7qrFHNmRVObfSvE+YXZ0OKr3MS
<br>
=wvB9
<br>
-----END PGP SIGNATURE-----
<br>
<br>
</body>
</html>

--------------040405000104070509070304--