Have you tried drop sequence?
On Sat, 31 Mar 2001, Jeff wrote:
> Hi,
>
> I've accidently deleted the file employees.key.seq, however there's still an
> entry in pg_class.
>
> It would not allow me to create employees.key.seq anymore because it thinks
> it already exists.
>
> How can I delete it
I was just wondering if using views offered any sort of a performance
increase when designing my database.
Shawn
> What do you consider "passing a parameter to the view" to be?
>
This is where Microsoft Access has twisted me :)
Access as you may or may not know allows you to use parameters in a query:
SELECT * FROM table WHERE table.pkey=[Enter The Primary Key];
The bit in [] represents a prompt to the us
>
> or
>
> SELECT outcome, count(outcome) FROM safety WHERE injdate='2000-11-14'
> GROUP BY outcome;
>
>
>
> Michael Fork - CCNA - MCP - A+
> Network Support - Toledo Internet Access - Toledo Ohio
>
> On Tue, 14 Nov 2000, shawn everett wrote:
>
I have a table defined as follows:
CREATE TABLE safety (
sid SERIAL,
side INTEGER,
InjDate DATE,
InjType INTEGER,
Outcome INTEGER,
PRIMARY KEY (sid)
);
What I'm trying to generate is a list of all outcomes and how many of each
that occured for a pa
I have a database of questions and I would like to be able to pull them
out randomly from the database using query.
I'm thinking of something along the lines of:
SELECT random() as RND,question
FROM Problems
ORDER BY RND;
Where random() is a user defined or built in function that returns a
ran
I may be horriblly out of my element here but, I'm going to jump in anyway
:)
If you mount a floppy and copy a large file to it, you will get a prompt
back fairly quickly.
If you type: sync right after
The sync command writes everything to the floppy as expected.
Shawn
On Tue, 31 Oct 2000, ma
