I'm going from the documentation in the Programmer's Guide, chapter 4.
I'd like to have the following type available in Postegres:
typedef struct FullName {
char *first;
char *last;
} FullName;
According to the docs, it looks like I need to do something like:
typedef struct FullName {
in
Folks,
I'm a bit confused on custom type declarations, actually. I'd like to
create a custom type for American phone numbers, such that:
It takes a string and returns something that looks like Varchar(22);
If someone types in 10 digits, it returns output like (###) ###-
If a user en
> Rodger Donaldson <[EMAIL PROTECTED]> writes:
> > SELECT url
> > FROM sites
> > WHERE url ~ url || '\\s+'
>
> > While this concatenation works with the LIKE directive (ie LIKE url || '%'),
> > postgresql barfs on it in a regexp with the error:
>
> > ERROR: Unable to identify an operator '||'
Josh Berkus <[EMAIL PROTECTED]> writes:
> I'm a bit confused on custom type declarations, actually. I'd like to
> create a custom type for American phone numbers, such that:
> ...
> 1. Can I reference a custom function (phoneformat) in a type definition?
Of course. The input and output c
Tom,
> However, building a new type for this seems like overkill, because you'd
> also have to supply a set of functions and operators for the type. It
> would be a lot less work just to provide a normalization function
> interpret_phone_no(text) returns text
> which could be invoked exp
> > 3. What sort of trouble am I going to get into trying to pull data from
> > a custom type into an external interface (i.e. PHP4)?
>
> Good question --- the interface code might or might not have a sensible
> default behavior for types it doesn't recognize.
Why not explicitly convert to tex
Josh,
> Thanks. You're probably right ... reformatting the phone numbers is
> going to be a lot less work than a custom type.
I remember from the old days of Delphi/InterBase, and even older days of
Paradox, there were so called input masks, US phone code mask would be like
(999)_000-00-00
KuroiNeko,
> I remember from the old days of Delphi/InterBase, and even older days of
> Paradox, there were so called input masks, US phone code mask would be like
Input masks still exist for some languages (VB, Paradox) but I've found
that even in those platforms that support them I tend to
Mr. Popkov,
> http://www.primechoice.com/hum/uspn.c
Thanks! Since I don't read C, I'll just have to compile it as a
function and try it out. To repay you, I'll write the function (in
PL/PGSQL) to strip out any extraneous characters that the user might
have added in data entry.
> KuroiNeko,
>
> > I remember from the old days of Delphi/InterBase, and even older days of
> > Paradox, there were so called input masks, US phone code mask would be like
>
> Input masks still exist for some languages (VB, Paradox) but I've found
> that even in those platforms that support t
Hi,
I am facing a problem in mapping between two tables containing unique
entries
T1 T2
_
| x1 | | y1 |
| x2 | | y2 |
| x3 | | y3 |
- -
x(i) points to 1 or more entries in T2. y(i) points to one or mor
11 matches
Mail list logo
