IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 1 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / "user-defined types" - would that be SQL-standard 'domains'?
Post #64,466
by CRConrad
11/22/02 9:37:28 AM
Reply
New "user-defined types" - would that be SQL-standard 'domains'?
If so, then that (along with roles and views and Idunno what all) is among the many IB/FB features I neglected to mention. As opposed to UDFs, which IIRC I *did* mention... :-)

So what are you saying -- that Larry is collecting a percentage from Seagate, Maxtor, et al?
   Christian R. Conrad
Microsoft is a true reflection of Bill Gates' personality - the sleaziest, most unethical, ugliest little rat's ass the world has seen unto this time. -- [link|http://z.iwethey.org/forums/render/content/show?contentid=42971|Andrew Grygus]
Post #64,467
by admin
Picture of admin
11/22/02 9:40:59 AM
Reply
New user-defined types
As in, write some external code with save/restore functions, etc., to make your very own new FarbleBanger base type.

[link|http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/xtypes.html|http://www.us.postgr...tgres/xtypes.html]
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
Post #64,480
by CRConrad
11/22/02 10:51:43 AM
Reply
New Wow, cool; the FB dev list is only now talking about that...
...kind of thing. Or, OK, they've been mentioning it, on and off, for a bit over a year AFAICR. But it ain't there yet. (Also somewhat reminiscent of how to build TField-descendant object classes, for client-side apps that attach to different kind of DBMSes, in Delphi; those "save/restore functions" are analogous to the getter/setter methods for the AsString property.)

Cool to see that PgSql seems to have copied IB's basic "multigenerational" ("multiversion", in Postgres-speak) architecture, too. (Doesn't seem quite consistently pervasive, though.)

Yeah yeah, I'll lay off the bashing... If the freaking WORLD lays off the hyping! :-)
   Christian R. Conrad
Microsoft is a true reflection of Bill Gates' personality - the sleaziest, most unethical, ugliest little rat's ass the world has seen unto this time. -- [link|http://z.iwethey.org/forums/render/content/show?contentid=42971|Andrew Grygus]
Post #64,481
by admin
Picture of admin
11/22/02 11:04:29 AM
Reply
New Postgres is really a research database
For trying out new things. People use it for the real world too, though. :-)

Some of the contrib items are pretty nifty as well, like the fulltext indexing I use here.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
     Excel 97 spreadsheet to Excel database + form. Tips? - (Another Scott) - (43) - Nov. 14, 2002, 08:16:32 AM EST
         I'd export to a delimited file - (drewk) - (14) - Nov. 14, 2002, 10:08:12 AM EST
             Thanks, but that's not what I'm looking for... - (Another Scott) - (13) - Nov. 14, 2002, 01:22:45 PM EST
                 There's another issue with XL. - (mmoffitt) - (12) - Nov. 15, 2002, 02:37:02 PM EST
                     Get warp and mesa - (jake123) - (11) - Nov. 15, 2002, 03:00:42 PM EST
                         REXX??? As in Tyrannosaurus? <vbg? -NT - (mmoffitt) - (10) - Nov. 15, 2002, 04:13:48 PM EST
                             Pretty much, considering - (jake123) - (9) - Nov. 15, 2002, 07:34:49 PM EST
                                 REXX is the pre-perl perl -NT - (wharris2) - (8) - Nov. 16, 2002, 09:58:28 PM EST
                                     Maybe... - (jake123) - (5) - Nov. 17, 2002, 01:18:19 PM EST
                                         Cheap shots :=) - (wharris2) - Nov. 17, 2002, 07:12:23 PM EST
                                         How is that a lot easier? - (ben_tilly) - (3) - Nov. 18, 2002, 12:00:25 AM EST
                                             I didn't say easier. - (jake123) - (2) - Nov. 19, 2002, 01:12:47 AM EST
                                                 OK, but... - (ben_tilly) - (1) - Nov. 19, 2002, 01:26:33 PM EST
                                                     Equivalent in REXX - (jake123) - Nov. 19, 2002, 01:58:54 PM EST
                                     BZZT - Utterly wrong - (deSitter) - (1) - Nov. 18, 2002, 04:30:31 AM EST
                                         know how you feel - (cforde) - Jan. 5, 2003, 01:57:05 AM EST
         Nah...its trivial in Access too. - (bepatient) - (8) - Nov. 14, 2002, 02:35:53 PM EST
             God, Beep! Bound Forms! Bleech! - (mmoffitt) - (7) - Nov. 15, 2002, 02:40:32 PM EST
                 It sounded like what he needed. - (bepatient) - (6) - Nov. 15, 2002, 04:11:00 PM EST
                     Understood. - (mmoffitt) - (5) - Nov. 15, 2002, 04:12:47 PM EST
                         Not knowing Access all that well... - (CRConrad) - (4) - Nov. 15, 2002, 04:48:48 PM EST
                             The problem with Access. - (static) - (1) - Nov. 16, 2002, 05:52:49 AM EST
                                 nutshell: Access expects denormalization. - (tseliot) - Nov. 16, 2002, 04:20:28 PM EST
                             Access has some "special features" - (mmoffitt) - (1) - Nov. 16, 2002, 05:11:06 PM EST
                                 Thanks, that's quite enough. On that other thing, though... - (CRConrad) - Nov. 16, 2002, 06:22:21 PM EST
         DTS? - (gdaustin) - (18) - Nov. 20, 2002, 10:18:13 PM EST
             Spreadsheet grows up to be a Real Application - (gdaustin) - (17) - Nov. 20, 2002, 10:38:33 PM EST
                 I'm looking at Access and MySQL now. - (Another Scott) - (16) - Nov. 21, 2002, 06:57:58 AM EST
                     Access, MySQL, PostgreSQL? Why don't you consider a REAL... - (CRConrad) - (15) - Nov. 21, 2002, 04:49:28 PM EST
                         Christian, WTF are you on about? - (admin) - (13) - Nov. 21, 2002, 05:03:11 PM EST
                             In that case, I'll point to one it *does* have: - (CRConrad) - (12) - Nov. 21, 2002, 07:03:19 PM EST
                                 Um, my tinfoil hat seem to work better on you than on admin. - (Another Scott) - (1) - Nov. 21, 2002, 10:23:35 PM EST
                                     Yours?!? Isn't it *I* who should be wearing one? - (CRConrad) - Nov. 22, 2002, 02:23:48 AM EST
                                 PostgreSQL Python drivers... - (admin) - (9) - Nov. 21, 2002, 11:33:32 PM EST
                                     Lot better than I thought... All your fault, though! ;^) - (CRConrad) - (8) - Nov. 22, 2002, 03:14:19 AM EST
                                         Re: Lot better than I thought... All your fault, though! ;^) - (admin) - (7) - Nov. 22, 2002, 05:32:44 AM EST
                                             "user-defined types" - would that be SQL-standard 'domains'? - (CRConrad) - (3) - Nov. 22, 2002, 09:37:28 AM EST
                                                 user-defined types - (admin) - (2) - Nov. 22, 2002, 09:40:59 AM EST
                                                     Wow, cool; the FB dev list is only now talking about that... - (CRConrad) - (1) - Nov. 22, 2002, 10:51:43 AM EST
                                                         Postgres is really a research database - (admin) - Nov. 22, 2002, 11:04:29 AM EST
                                             That...is frickin cool. - (tseliot) - (1) - Nov. 22, 2002, 11:41:26 AM EST
                                                 What, the inheritance? - (admin) - Nov. 22, 2002, 11:46:22 AM EST
                                             Cool! - (deSitter) - Nov. 22, 2002, 11:47:06 AM EST
                         I glanced at it, but didn't bite. - (Another Scott) - Nov. 21, 2002, 05:41:03 PM EST

Ooops, I'm ranting again... time to get more coffee.
70 ms