On Mon, Jul 04, 2005 at 16:10:03 -0700,
Din Adrian <[EMAIL PROTECTED]> wrote:
>
> Yes , I know what sequence is, but our procedure for generating doc
> numbers is v. big and has manny (4) parameters and we did'nt use sequence
> in it for this reason ....
Then use a sequence for part of the number.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match