|
|
Sponsored Content
The Lounge
What is on Your Mind?
Who would you employ?
Post 302953225 by rbatte1 on Wednesday 26th of August 2015 05:20:32 AM
08-26-2015
Moderator
I would employ someone from this board, preferably one with the handle wisecracker That candidate seems a perfect employee 
But ignoring the blatant sycophancy and assuming that you wish to escape, I would humbly suggest you seek one who is:-
In larger companies, a good Personnel or H.R. department may well have puzzles that stretch the mind and allows you to observe the process. That may give you an insight too. Additionally, try to set some puzzles of your own, e.g. try to get them to describe the difference between truncate table table_name ; and delete from table_name ;
It might sound like passing the responsibility, but I have had too much experience of very qualified people who don't have a clue, and when you consider the cheating that is common in some places where some people may have obtained qualifications, they become worth even less, which I'm sure for some is a grave injustice.
Robin
But ignoring the blatant sycophancy and assuming that you wish to escape, I would humbly suggest you seek one who is:-
- generally bright rather than qualified
- open to ideas
- old enough not to be GUI-only
- doesn't have a fancy looking C.V., but has content over visuals
- who can read manuals well
- is not scared by problems and will ask for help
In larger companies, a good Personnel or H.R. department may well have puzzles that stretch the mind and allows you to observe the process. That may give you an insight too. Additionally, try to set some puzzles of your own, e.g. try to get them to describe the difference between truncate table table_name ; and delete from table_name ;
It might sound like passing the responsibility, but I have had too much experience of very qualified people who don't have a clue, and when you consider the cheating that is common in some places where some people may have obtained qualifications, they become worth even less, which I'm sure for some is a grave injustice.
Robin
These 3 Users Gave Thanks to rbatte1 For This Post:
|
|
2 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a variable, $sername, and I would like to display this variable only if it *does not* contain either of these two tags: *DTI*FA* or *DIFF*FA*.
I think the syntax for my 'or' operator is off. The variable $sername is continuously changing in an outer loop (not shown), but at the... (4 Replies)
Discussion started by: goodbenito
4 Replies
2. Shell Programming and Scripting
Hello experts,
I'm stuck with this script for three days now. Here's what i need.
I need to split a large delimited (,) file into 2 files based on the value present in the last field.
Samp: Something.csv
bca,adc,asdf,123,12C
bca,adc,asdf,123,13C
def,adc,asdf,123,12A
I need this split... (6 Replies)
Discussion started by: shell_boy23
6 Replies
LEARN ABOUT SUSE
create_constraint_trigger
CREATE CONSTRAINT
TRIGGER(7) SQL Commands CREATE CONSTRAINT TRIGGER(7) NAME
CREATE CONSTRAINT TRIGGER - define a new constraint trigger SYNOPSIS
CREATE CONSTRAINT TRIGGER name AFTER event [ OR ... ] ON table_name [ FROM referenced_table_name ] { NOT DEFERRABLE | [ DEFERRABLE ] { INITIALLY IMMEDIATE | INITIALLY DEFERRED } } FOR EACH ROW EXECUTE PROCEDURE funcname ( arguments ) DESCRIPTION
CREATE CONSTRAINT TRIGGER creates a constraint trigger. This is the same as a regular trigger except that the timing of the trigger firing can be adjusted using SET CONSTRAINTS [set_constraints(7)]. Constraint triggers must be AFTER ROW triggers. They can be fired either at the end of the statement causing the triggering event, or at the end of the containing transaction; in the latter case they are said to be deferred. A pending deferred-trigger firing can also be forced to happen immediately by using SET CONSTRAINTS. PARAMETERS
name The name of the constraint trigger. This is also the name to use when modifying the trigger's behavior using SET CONSTRAINTS. The name cannot be schema-qualified -- the trigger inherits the schema of its table. event One of INSERT, UPDATE, or DELETE; this specifies the event that will fire the trigger. Multiple events can be specified using OR. table_name The (possibly schema-qualified) name of the table in which the triggering events occur. referenced_table_name The (possibly schema-qualified) name of another table referenced by the constraint. This option is used for foreign-key constraints and is not recommended for general use. DEFERRABLE NOT DEFERRABLE INITIALLY IMMEDIATE INITIALLY DEFERRED The default timing of the trigger. See the CREATE TABLE [create_table(7)] documentation for details of these constraint options. funcname The function to call when the trigger is fired. See CREATE TRIGGER [create_trigger(7)] for details. arguments Optional argument strings to pass to the trigger function. See CREATE TRIGGER [create_trigger(7)] for details. COMPATIBILITY
CREATE CONSTRAINT TRIGGER is a PostgreSQL extension of the SQL standard. SEE ALSO
CREATE TRIGGER [create_trigger(7)], DROP TRIGGER [drop_trigger(7)], SET CONSTRAINTS [set_constraints(7)] SQL - Language Statements 2010-05-14 CREATE CONSTRAINT TRIGGER(7)