On Thu, Feb 24, 2011 at 3:03 AM, Tom Lane t...@sss.pgh.pa.us wrote:
John R Pierce pie...@hogranch.com writes:
On 02/23/11 4:44 AM, Stephane Bortzmeyer wrote:
*3. Start-End IP format :* 1.2.3.0-1.2.3.255
You don't even need to program the conversion, it is already done:
% netmask
On Thu, Feb 24, 2011 at 1:10 AM, Michael Glaesemann g...@seespotcode.netwrote:
On Feb 23, 2011, at 13:49, John R Pierce wrote:
On 02/23/11 4:44 AM, Stephane Bortzmeyer wrote:
*3. Start-End IP format :* 1.2.3.0-1.2.3.255
You don't even need to program the conversion, it is already
a regular varchar or text field.
On 02/23/2011 02:09 PM, Gaini Rajeshwar wrote:
Hi All,
I wanted to store ip addresses in table. I wanted to support the
following 3 types of ip addresses.
|*1. Wildcard format :* 1.2.3.*
*
*|
|*2. CIDR format:* 1.2.3/24 OR
On Wed, Feb 23, 2011 at 02:30:18PM +0200,
Sim Zacks s...@compulab.co.il wrote
a message of 97 lines which said:
a regular varchar or text field.
Very bad idea since they don't support canonicalization (2001:db8::1
== 2001:db8:0:0:0:0:0:1) or masking (set_masklen(address, 20)).
--
Sent via
On Wed, Feb 23, 2011 at 05:39:26PM +0530,
Gaini Rajeshwar raja.rajeshwar2...@gmail.com wrote
a message of 52 lines which said:
I wanted to store ip addresses in table. I wanted to support the following 3
types of ip addresses.
*1. Wildcard format :* 1.2.3.*
*
*
*2. CIDR format
On 02/23/11 4:44 AM, Stephane Bortzmeyer wrote:
*3. Start-End IP format :* 1.2.3.0-1.2.3.255
You don't even need to program the conversion, it is already done:
% netmask 1.2.3.0:1.2.3.255
1.2.3.0/24
yes, but what about 10.1.2.57-10.1.2.123 ?presumably valid in his
range
On Feb 23, 2011, at 13:49, John R Pierce wrote:
On 02/23/11 4:44 AM, Stephane Bortzmeyer wrote:
*3. Start-End IP format :* 1.2.3.0-1.2.3.255
You don't even need to program the conversion, it is already done:
% netmask 1.2.3.0:1.2.3.255
1.2.3.0/24
yes, but what about
John R Pierce pie...@hogranch.com writes:
On 02/23/11 4:44 AM, Stephane Bortzmeyer wrote:
*3. Start-End IP format :* 1.2.3.0-1.2.3.255
You don't even need to program the conversion, it is already done:
% netmask 1.2.3.0:1.2.3.255
1.2.3.0/24
yes, but what about 10.1.2.57-10.1.2.123 ?
On 02/23/11 1:33 PM, Tom Lane wrote:
The question is does he actually have a use-case for address ranges that
don't correspond to legal CIDR ranges, but do nonetheless have an
identifiable lower boundary, upper boundary, and no holes? And if so,
what is it? The whole thing looked to me like
Character will use more disk space than varchar so it does make a
difference.
http://www.postgresql.org/docs/8.3/interactive/datatype-character.html
Values of type character are physically padded with spaces to the
specified width n, and are stored and displayed that way. However, the
Roberts, Jon [EMAIL PROTECTED] writes:
Character will use more disk space than varchar so it does make a
difference.
char also has very peculiar comparison semantics. Unless your strings
are really truly fixed-length, you should just about always use varchar.
regards,
PROTECTED]
Sent: Mon, 23 Jun 2008 15:00:05 -0400
Subject: Re: [GENERAL] Data Types
Roberts, Jon [EMAIL PROTECTED] writes:
Character will use more disk space than varchar so it does make a
difference.
char also has very peculiar comparison semantics. Unless your strings
are really
Try pg_type. typname should give you what you're looking for.
On Dec 30, 2005, at 1:57 PM, Jonel Rienton wrote:
Hi guys,
Does Postgres store all the possible column datatypes somewhere in its
system tables? Like int8, int4, character varying, etc. I'm trying
to write
another GUI client
Thank you gentlemen, this will keep me busy for a while.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of James Cradock
Sent: Friday, December 30, 2005 1:05 PM
To: Jonel Rienton
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Data types
Try
Title: RE: [GENERAL] Data types?
I thought:
\dT
This should do it
Ben
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: 08 March 2001 01:00
To: Christopher Sawtell
Cc: Flemming Frøkjær; [EMAIL PROTECTED]
Subject: Re: [GENERAL] Data types
On Thu, 08 Mar 2001 12:29, Flemming Frkjr wrote:
How do i find out what data types are available in PostgreSQL.
I know there are more that the ones in the docs, and i ones saw a
command to list all the data types. And there was a lot more than the
ones from the docs.
Look in the regression
Christopher Sawtell [EMAIL PROTECTED] writes:
On Thu, 08 Mar 2001 12:29, Flemming Frøkjær wrote:
How do i find out what data types are available in PostgreSQL.
Look in the regression tests. Interesting stuff.
And there's always "select * from pg_type" ... not to mention the source
code ...
17 matches
Mail list logo