Suggestions please: names for function cachabilityattributes 
Author Message
 Suggestions please: names for function cachabilityattributes

Quote:
Tom Lane writes:
> case 1: "immutable"
> case 2: "mutable", or perhaps "stable"
> case 3: "volatile"

Since they've changed anyway, how about dropping the silly "is" in front
of the names?

--

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Wed, 29 Sep 2004 14:05:34 GMT
 Suggestions please: names for function cachabilityattributes

Quote:

> Tom Lane writes:
>> case 1: "immutable"
>> case 2: "mutable", or perhaps "stable"
>> case 3: "volatile"
> Since they've changed anyway, how about dropping the silly "is" in front
> of the names?

"volatile" would conflict with a C keyword.  Possibly we could get away
with this at the SQL level, but I was worried...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Wed, 29 Sep 2004 14:07:59 GMT
 Suggestions please: names for function cachabilityattributes

Quote:
Tom Lane writes:

> > Tom Lane writes:
> >> case 1: "immutable"
> >> case 2: "mutable", or perhaps "stable"
> >> case 3: "volatile"

> > Since they've changed anyway, how about dropping the silly "is" in front
> > of the names?

> "volatile" would conflict with a C keyword.  Possibly we could get away
> with this at the SQL level, but I was worried...

In general, I was thinking about migrating the CREATE FUNCTION syntax more
into consistency with other commmands and with the SQL standard.
Basically I'd like to write

    CREATE FUNCTION name (args, ...) RETURNS type
      AS '...'
      LANGUAGE foo
      STATIC
      IMPLICIT CAST

(where everything after RETURNS can be in random order).

OK, so the key words are not the same as SQL, but it looks a lot
friendlier this way.  We're already migrating CREATE DATABASE, I think,
and the names of the options have changed, too, so this might be a good
time.

--

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Wed, 29 Sep 2004 14:29:45 GMT
 Suggestions please: names for function cachabilityattributes

Quote:

> Basically I'd like to write
>     CREATE FUNCTION name (args, ...) RETURNS type
>       AS '...'
>       LANGUAGE foo
>       STATIC
>       IMPLICIT CAST
> (where everything after RETURNS can be in random order).

No strong objection here; but you'll still have to accept the old syntax
for backwards compatibility with existing dump scripts.  I also worry
that this will end up forcing us to reserve a lot more keywords.  Not so
much for CREATE FUNCTION, but in CREATE OPERATOR, CREATE DOMAIN and
friends I do not think you'll be able to do this without making the
keywords reserved (else how do you tell 'em from parts of typenames
and expressions?).

Given that it's not gonna be SQL-spec anyway, I'm not entirely sure
I see the point of changing.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Wed, 29 Sep 2004 23:35:22 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Suggestions please: names for function cachabilityattributes

2. Suggestions please: names for function

3. Suggestions please: names for function cachability

4. Suggestions please: names for function cachability attributes

5. HELP: ODBC function to return database name and path from DataSoure Name

6. Suggestion for aggregate function

7. Suggestion for aggregate function

8. Suggestions on moving databases to new server with same name

9. Looking for suggestions for styleguide SQL programming and naming conventions

10. Suggestions for naming conventions

11. Dynamically naming tables or other suggestions?

12. VMark/Unidata Name Suggestions


 
Powered by phpBB® Forum Software